31
Quote:
We'll back to the problem. Yes I did the "/usr/local/mysql/bin/mysql -u root -p password -h `hostname` xxx" and it gave me the whole nine yards of help page tips. Tried it without the "xxx" (replaced with my real pw) at the end and the ended up with an error message: "ERROR 1102: Incorrect dabase name 'edquist.se-local'" wich happens to be the name of my host... not my database.
Sounds like the arguments are not getting read correctly.
/usr/local/mysql/bin/mysql -u <username> -p <optional_password> -h <hostname> <databasename>
'xxx' in the position you have it above is your desired *database* not the password. The password should go right after the "-p" (or omit it and you will be prompted for it -- safer!). You shouldn't be typing the string "password" anywhere. Also try NOT putting the backticks around the hostname... I think that is causing some problems too.
So for example:
/usr/local/mysql/bin/mysql -u root -p -h localhost xoops
where 'localhost' should be replaced with your database hostname, and 'xoops' should be replaced with your desired database to connect to. (Note you can leave out the database name and just type 'connect xoops' once you get into the MySQL shell.
Good luck