Hi everyone,

I just installed mySQL on my RAQ3. I've never used mySQL before now so I'm not sure what I'm doing wrong/right. Once I login as root on SSH I think I'm supposed to type something along the lines of...mysqladmin -uroot -pcobalt-mysql
I read somewhere that the default user/pass is as above. Unfortunately, the error comes up after this as...

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' failed


Any help on this would be appreciated, and remember, newbie here :)

Well, seems like a password error. Are you sure that you did'nt changed the password ?


Salam,
-Omair

the command is:

mysqladmin -uroot -pcobalt-mysql password XXXXXXX

Where XXXXXXX should be the 'actual' new password. The rest should be typed as is.

Also be sure you are doing:
After you login as admin, be sure to su to root. This command must be run as root, not admin.

I had trouble with mysaql on a Raq, also:

http://webhostingtalk.com/showthread.php?s=&threadid=23554

Thanks for the replys guys. The following line seems to run ok
mysqladmin -uroot -pcobalt-mysql
...probably because it doesn't do anything ? It runs down a list of commands which you can use with mysql. The error arrises when I try to, for example, change the password. I know I am logged in as root and the passwords, should be set to default as I just installed the .pkg file. The error is same as in my first post.

I don't think it's a software error or disrupt file etc as very little 'messing about' has been going on since I got it a few weeks back. It's probably a litte silly thing :crap:, but I've double-checked spelling and continue to walk around in circles.

Is there an 'on' button somewhere which turns on mySQL ? just thinking.

ok, I just logged in and typed 'mysql' this brought up a mysql command prompt which I entered 'show databases' (a little something I learned @ mysql.com :D ) This brings up TWO databases, mysql and test ? are these default settings too ? both appear to be empty.

Does anybody know is there a file which hard codes the username + passwords so I could retrieve it as I'm getting the feeling that the password is wrong ? :confused: ?

Originally posted by Chicken
mysqladmin -uroot -pcobalt-mysql password XXXXXXX

Where XXXXXXX should be the 'actual' new password. The rest should be typed as is.
You tried this and what happened again? And yes, those two db's are installed by default. I removed them.

... I get the error >

error: 'Access denied for user: 'root@localhost' failed

It just looks like a password error, dunno? Is there an easy way of re-installing it/resetting the password.

I'd try this http://www.mysql.com/doc/R/e/Resetting_permissions.html