connecting to the server

[rs51]

hi
if i make
shell>mysql
i enter without problems; but if i use:
shell>mysql root mypassword,
i get this message:
error 2045 access denied for user:ODBC@127.0.0.1 (using password yes)
So, without password, i enter, but when i enter my passowrd...i cant enter.
What's going on?

 

[sleipnir214]

What user credentials have you set up in MySQL?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[QatQat]

What are you running MySQL on?

Windoz version has got the funny behavior of not considering 127.0.0.1 = localhost


Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[rs51]

i have winXP and IIS 5;
i made the instalation guided by Kevin Yank's book "building your own Database driven website using php and mysql".I think its root and localhost...

 

[QatQat]

do the following


c:\net stop mysql


then


c:\net start mysql --skip-grant-tables

then login as root with no password

at mysql prompt


mysql>GRANT ALL
mysql>on *.*
mysql>to root@'%'
mysql>identified by "yourpass"
mysql>WITH GRANT OPTION
mysql>;

mysql>flush privileges;

quit

restart the server normally

c:\net stop mysql

c:\net start mysql


login as root with the password


Bye


Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[rs51]

hi and thanks to everybody who tried to help!
i made the sugested instructions and then i got this error:

ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)

after writing:
mysql>GRANT ALL
mysql>on *.*
mysql>to root@'%'
mysql>identified by "mypassword" [i tried "", '' and nothing around my password.]
mysql>WITH GRANT OPTION
mysql>;

...What now?

 

[QatQat]

Try the last option

GRANT ALL
ON *.*
to root@'127.0.0.1'
identified.......
.......

If not succesful,


I think you are left with the typical Windoz option,


reinstall!

Trying to debug Windoz problems is almost impossible.
Linux version configuration and debugging on the other hand are much more user friendly.


Save all your databases,

c:\mysql\data\*.*



Reinstall and setup root rights immediately before restoring DBs.


Bye


Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.