You are not logged in.

#1 2007-09-01 11:34:17

TreeMinds
Member
Registered: 2007-09-01
Posts: 35

Problem using mysql

I followed the guide : http://wiki.archlinux.org/index.php/LAMP
As root I give: 'mysql' command and I take the following error :

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

My host name isnt localhost. Maybe this is the problem?

Last edited by TreeMinds (2007-09-01 11:37:29)

Offline

#2 2007-09-01 11:51:50

lucke
Member
From: Poland
Registered: 2004-11-30
Posts: 4,018

Re: Problem using mysql

You should use those later commands (mysqladmin -u root password YOUR_PASSWORD; mysql -u root -p").

localhost always denotes your own PC.

Offline

#3 2007-09-01 12:14:56

TreeMinds
Member
Registered: 2007-09-01
Posts: 35

Re: Problem using mysql

OK I found the problem, I've set for password 'roots_password' (from copy paste)
How I can change the password?
'mysqladmin -u root password 'YOUR_PASSWORD'  wont work.
Thanks a lot.

Now an other question,
Never Mind...

Last edited by TreeMinds (2007-09-01 12:56:05)

Offline

#4 2007-09-01 12:50:27

lucke
Member
From: Poland
Registered: 2004-11-30
Posts: 4,018

Re: Problem using mysql

"mysqladmin -u root -p password your_new_desired_password" and enter old password when prompted.

Are you in a proper directory? Browse a bit.

Offline

#5 2007-09-01 12:56:43

TreeMinds
Member
Registered: 2007-09-01
Posts: 35

Re: Problem using mysql

I wasnt in the proper dir, sorry about that...

Offline

#6 2007-09-01 13:05:25

TreeMinds
Member
Registered: 2007-09-01
Posts: 35

Re: Problem using mysql

Ok everything, thanks a lot!

Last edited by TreeMinds (2007-09-02 00:14:45)

Offline

Board footer

Powered by FluxBB