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.