DamianHart wrote:(1) the line I had to type was pretty long. Is there a way to set a mysql.exe shortcut on the desktop so that I can get the window up and running without all that typing?
DamianHart wrote:(2) when I was fooling around initially, I opened the xampp mysqladministrator window and it asked me for a user name and password which it then put in the my.ini file. However when I used that info in the startup string, it didn't work. Remembering that the default was root / <empty> I tried that and it didn't work. Then I started tinkering and eventually used root as the user and my password as the password. Why did it accept the password I entered, but not the username I entered? Should I try to get it to accept a username other than root...or should I just not bother?
Is there a way to set a mysql.exe shortcut on the desktop so that I can get the window up and running without all that typing?
Can I run the mysql.exe (or the GUI interface if I figure it out) on my computer but have it create / acccess the databases on the server in the other room?
Now when I look at the admin panel I see a field labeled Local Host Name with a name there...let's say it's FOO...
So, how then do I write the connection line to use FOO as the --host?
I tried a few different ways, but got "cannot connect" errors.
But the MySQL server must allow connections from a remote pc for a given user name. That's not true for the user "root". (you can change this with e.g. phpMyAdmin or local with "mysql.exe")
Users browsing this forum: No registered users and 79 guests