Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th November 2008, 13:25
kokeroulis kokeroulis is offline
Junior Member
 
Join Date: Nov 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 12th November 2008, 14:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by kokeroulis View Post
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 View Post
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 View Post
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).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 12th November 2008, 19:37
kokeroulis kokeroulis is offline
Junior Member
 
Join Date: Nov 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

ok.thanks.
Reply With Quote
Reply

Bookmarks

Tags
mysql, password, phpmyadmin

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 01:05
Perfect Setup Ubuntu 7.04: MySQL host password problem cheros HOWTO-Related Questions 6 10th January 2008 16:30
Ubuntu 6.06 LTS during ISPConfig MySQL root password error...stuck?? Randall Hoffman General 5 13th March 2007 15:01
ISPConfig Mysql root password issue ?? Stuck at install Randall Hoffman Installation/Configuration 1 16th January 2007 20:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 01:41


All times are GMT +2. The time now is 06:29.


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