Mailinglist Archive: opensuse (4343 mails)

< Previous Next >
Re: [SLE] mysql root permission denied
  • From: steve <fsanta@xxxxxxxxxx>
  • Date: Thu, 7 Nov 2002 16:30:48 +0000
  • Message-id: <200211071630.48695.fsanta@xxxxxxxxxx>
On Thursday 07 November 2002 14:09, you wrote:
> 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.

Exactly the same! Let's give up no? If anyone thinks of anything, them please
let me know. THanks. Steve.


< Previous Next >
Follow Ups
References