LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

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

Rep: Reputation: 0
goof


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
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,539

Rep: Reputation: 149Reputation: 149
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
alar
Member
 
Registered: Sep 2003
Location: Canada
Distribution: CentOS 5.5, Ubuntu 10.04, Linux Mint 11 gnome 64 bit
Posts: 336

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>

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>

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
Bye
allison@bilbo:/etc/init.d$ sudo /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server
from pid file /var/run/mysqld/mysqld.pid
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.
allison@bilbo:/etc/init.d$
mysql -u root
 
  


Reply

Tags
mysql


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


All times are GMT -5. The time now is 04:27 PM.

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