Lost mysql root password on slack server

iiKster · 12-13-2008, 03:26 AM

I am new to the forum so i apologize if I have posted this in the wrong place...

So the actual problem:
I have Slack 12 on a computer that acts as a web server. I tried to install MySQL a few days back and as I am fairly new to Linux I don't have a clue what I did. Somewhere the root password got lost an now when i try to get in to MySQL the following happens:

Quote:

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

Is there a way to change the root password for MySQL if you don't know the current password? Alternatively, how do I get rid of the current MySQL installation in order to install a new one?

twisted1919 · 12-13-2008, 03:34 AM

how did you installed the mysql server ?
Compiled from sources , or with installpkg ?
If you did with installpkg then run pkgtool and remove the package from there ...
But , slackware comes with mysql server by default , why did you installed other version of mysql server ?

iiKster · 12-13-2008, 04:09 AM

Let me refrace, i run

Quote:

mysql_install_db

twisted1919 · 12-13-2008, 04:49 AM

well that means you used the mysql server that comes with slackware by default .
To remove it , do it with removepkg tool , then , you can install a newer version of mysql .
You can download a new version from here http://slackware.osuosl.org/slackwar.../slackware/ap/
is allready compiled for slackware 12.2 so it works ok (even if you have slackware 12.1)

Hope this helps

Oh , let me show you something else :

Code:

root@linux-box11:/var# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

This happens because the syntax is not correct ...
The right way to do it is :

Code:

root@linux-box11:/var# mysql -u root -p
Enter password:  
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 699
Server version: 5.0.67 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

iiKster · 12-13-2008, 04:54 AM

I think i got it working...

Code:


root@geldar:/etc/rc.d# mysqld_safe --skip-grant-tables &
[1] 28787
root@geldar:/etc/rc.d# nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql

root@geldar:/etc/rc.d# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.37 Source distribution

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("NewPasswd") where User='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

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

mysql> quit
Bye

root@geldar:/etc/rc.d# /etc/rc.d/rc.mysqld stop

root@geldar:/etc/rc.d# /etc/rc.d/rc.mysqld start
root@geldar:/etc/rc.d# nohup: redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql


root@geldar:~# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

twisted1919 · 12-13-2008, 05:06 AM

Great news then

Penthux · 12-29-2008, 05:30 PM

There's a nice little how-to if you ever forget your MySQL root password:

Halt MySQL:
# /etc/rc.d/rc.mysql stop

Start MySQL in safe mode:
# mysqld_safe –skip-grant-tables &

Login to MySQL as root user:
# mysql -u root

Change the root user password:
mysql> use mysql;
mysql> update user set password=PASSWORD(”NEWPASSWD”) where user=’root’;
mysql> flush privileges;

** Your new MySQL root user password is now: NEWPASSWD
** Change this to your own preference.

Quit MySQL:
mysql> \q

Restart MySQL:
# /etc/rc.d/rc.mysql restart

# mysql --password=NEWPASSWD

## eof

I know this thread is a couple of weeks old now but this may help in future. :>