hi and thanks for reading. extreme newbie alert...




can anyone possibly give me some mysql help possibly over PM or AOL IM?

i'm having the worst of times with this thing right now.

i have just uninstalled the cobalt mysql .37 package, reinstalled it, and immediatly attempted to change the password according to cobalts "how-to" on changing the root mysql password.

aaand, i get:

[root admin]# mysqladmin -uroot -pcobalt-mysql password NEW_PASSWORD

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'




which is just the beginning of my troubles.

argh! any help is appreciated. i've had 6 days now of RaQ experience, and i've been hacking away at mysql for 3 days straight now.

When I did this I had the same kind of problems. I was trying
-u cobalt when you see the example -ucobalt you think it would need the space, it doesn't. You need to type the things exactly like cobalt. Or get something like webmin , phpmyadmin and use them (it is easier).

yeah, i figured that out early on after a few tries. that's no problem at all. thank you.


i've seen this problem addressed about 50 times on various forums, and there's been about 15 different answers. none of which have worked for me...

my problems began with root@localhost unable to connect on phpmyadmin (hence my other post)....

however, i'm completely stuck now.

telnet into your server and then type:

mysql -uroot -p

then it would ask you for your password.. by default it is cobalt-mysql

enter and you would be logged in!
then type this:

update mysql set password='NEW_PASSWORD';

Hope that might help!

- Omair

hi and thanks. unfortunately, still no luck.

[root /]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)


[root /]# mysql -uroot -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

Hmmm..

Can you tell us how did you installed mySQL. I mean to say any article you used as a reference ? Did you used the pkg file or RPM ?

Which version of mySQL is installed ?


- Omair

sure.


i installed the .37 PKG from the nl.cobalt pkg site. changed the password. which worked fine. started installing phpmyadmin. got the access denied for root@localhost error.

uninstalled the .37 PKG. re-installed the .37 PKG from the same nl.cobalt pkg site.

now, attempting to change the password, i get the same access denied error.

under admin, i can login to mysql.


i have been told i need to shut down the mysql server, then restart it with the --skip-grant-tables option then check the
contents of the user table.

which, i can shut down and restart the mysql server, but, starting with the --skip-grant-tables option and checking the contents of the user table are a few lightyears beyond my ability..

thanks for the help by the way!! =)

You never replied to the PM I sent, so I'm still not sure where you are in all of this, but...

Omair, the one thing I've figured out is that he's installed mysql before and changed the root pass. The default one is gone. I'm assuming he knows the root pass he's changed it to, but if not, then there's a process you have to follow to reset the root pass.

You should be 'root' when you try to connect to the mysql server, I can't tell if you are trying to do any or all of this from being logged in as 'admin' or not...

"under admin, i can login to mysql"

This is what makes me wonder.

Aside from that, if you have a fresh installation of mysql on the server, and it is running, but you cannot connect to it while logged in as 'root', I'd go forward as if you've lost the root pass and change it (instructions on mysql web site).

hey chicken.
oh poop. i never received a notice that i had a new PM. sorry about that!!!


yes, i have changed the password before on a previous installation, however, even the password that i changed it to no longer works. i'm going to go and reset the password.

i am trying to connect as under root. i had just noticed that i'm able to login to the mysql server under admin when i typed that in.

i'll get back with you on the PM chicken. thank you again for all of your help.

yes, i finally figured it out this morning!

i shut down the mysql server, attempted to restart it with --skip-grant-tables. still got access denied.

restarted safe_mysql with --skip-grant-tables, THEN, phpmyadmin worked, and i was able to edit the user tables, and add the privelages for root AND change the password using phpmyadmin.
took me 6 days to figure out & only 3 minutes to fix. sheesh.

i can't believe how many posts i've read with people having the same problems....whew...

i've gone from hating mysql & phpmyadmin to loving it completely within a span of 5 minutes.


thank you all for your help!