Latest LQ Deal: Latest LQ Deals
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-14-2007, 09:21 PM   #1
LQ Newbie
Registered: Nov 2007
Posts: 4

Rep: Reputation: 0

I was trying to configur mysql but screwed it up. it wants a password , i never gave it a password.
could i reset the whole thing and start over.
Old 11-15-2007, 04:12 PM   #2
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,696

Rep: Reputation: 232Reputation: 232Reputation: 232
Moved: This thread is more suitable in Linux-Software and has been moved accordingly to help your thread/question get the exposure it deserves.

The default password is usually blank. Have you tried it?
Old 11-17-2007, 08:15 PM   #3
Registered: Sep 2003
Location: Canada
Distribution: Fedora 30
Posts: 341

Rep: Reputation: 36
allison@bilbo:/etc/init.d$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.22-Debian_0ubuntu6.06.3-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update user set password=PASSWORD("") where User='root';
Query OK, 5 rows affected (0.00 sec)
Rows matched: 5 Changed: 5 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
allison@bilbo:/etc/init.d$ sudo /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server
from pid file /var/run/mysqld/
mysqld_safe[16350]: ended
[1]+ Done sudo mysqld_safe --skip-grant-tables
allison@bilbo:/etc/init.d$ sudo /etc/init.d/mysql start
Starting MySQL database server: mysqld.
mysql -u root



Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display\Resolution settings goof... Decepticon22 Linux - General 2 11-02-2005 09:25 PM
Apt / Synaptic goof BenGoodrich Debian 3 08-16-2005 04:07 AM
Newbie Goof!! TChumley Debian 5 11-23-2004 11:34 AM
mounting goof up paragon Linux - Newbie 2 05-14-2004 12:06 PM
Goof up in fstab! marksstroud Linux - Newbie 3 10-14-2001 01:24 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:02 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration