Re: Getting errors when trying to start MySQL after installing

[Jon Christenson]

I was able to start the database using mysqld_safe and run mysql_upgrade however it appears that the root user was not created:

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

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

mysql> UPDATE mysql.user SET Password=PASSWORD('test123') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

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

mysql> SELECT User FROM mysql.user;
Empty set (0.00 sec)