Forgot root password for mysql, problem resetting
I forgot my password for mariadb which I'm running as a drop-in replacement for mysql. Figured I'd just follow the standard reset directions to get myself out of the mess. I'm running Ubuntu 11.10.
I tried running this set of commands:
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysql stop
/etc/init.d/mysql start
Problem is, when I get to the step to run mysqld_safe, I get this message from terminal:
120730 18:47:37 mysqld_safe A mysqld process already exists
I ran a check, and after killing the mysql with /etc/init.d/mysql I get this:
user@server:/var/run$ sudo /etc/init.d/mysql stop
* Stopping MariaDB database server mysqld [ OK ]
user@server:/var/run$ sudo service mysql status
mysql start/running, process 31639
I'm not sure what is going on here. It seems I've got two mysql installations or I'm doing something wrong. I thought I'd fully uninstalled mysql when I installed mariadb. Just confused here, and could really use help to get in and change that blasted pw.