HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   Mysql problem with password (http://www.howtoforge.com/forums/showthread.php?t=28610)

kokeroulis 11th November 2008 13:25

Mysql problem with password
 
Hello. I am using ubuntu 8.04

i have follow the instructions of this page

Code:

http://www.howtoforge.com/ubuntu_lamp_for_newbies
and in the step in which i must press

Code:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
it came up the following error

Code:

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

i read this page and i do everything but when i am pressing the comand

Code:

/usr/bin/mysqld --skip-grant-tables --user=root
the terminal stucks (the above command doesn't work).

What should i do to fix it?

Also i want my mysql to be local.So should i change the?
Code:

bind-address = 127.0.0.1
And finaly how can i run the phpmyadmin.I have install it but i don't know how to run it.

Please help me

falko 12th November 2008 14:00

Quote:

Originally Posted by kokeroulis (Post 154546)
Hello. I am using ubuntu 8.04

i have follow the instructions of this page

Code:

http://www.howtoforge.com/ubuntu_lamp_for_newbies
and in the step in which i must press

Code:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
it came up the following error

Code:

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


Please try
Code:

mysqladmin -u root password yourpassword
instead.

Quote:

Originally Posted by kokeroulis (Post 154546)
Also i want my mysql to be local.So should i change the?
Code:

bind-address = 127.0.0.1

No, don't change it.

Quote:

Originally Posted by kokeroulis (Post 154546)
And finaly how can i run the phpmyadmin.I have install it but i don't know how to run it.

Try
http://1.2.3.4/phpmyadmin/ (replace 1.2.3.4 with the server's IP address or hostname).

kokeroulis 12th November 2008 19:37

ok.thanks.


All times are GMT +2. The time now is 10:59.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.