Mailinglist Archive: opensuse (4343 mails)

< Previous Next >
Re: [SLE] mysql root permission denied
  • From: sjb <ottaky@xxxxxxxxxx>
  • Date: Thu, 07 Nov 2002 14:09:47 +0000
  • Message-id: <3DCA742B.7050006@xxxxxxxxxx>
steve wrote:

# 021107 14:51:27 mysqld: Table 'mysql.host' doesn't exist

Ahh .. now we're getting somewhere.

OK, can you start mysql again

rcmysql start

Then login as an ordinary user

mysql

Then

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> desc host;
+-----------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host | char(60) binary | | PRI | | |
| Db | char(64) binary | | PRI | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+-----------------+------+-----+---------+-------+
12 rows in set (0.01 sec)

And if you don't see a table def like that above (which you probably won't) it means that the mysql_install_db probably failed somewhere along the line.

As for fixing it .. err .. uninstall mysql, then re-install it and (as root) run the mysql_install_db script again.

sjb


< Previous Next >
Follow Ups
References