List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 28 2001 2:40am
Subject:Re: User privs in mysql
View as plain text  
At 12:55 AM +0100 5/27/01, Gordon Stewart wrote:
>hi List
>I have a database in mysql that has to be used as root user.
>When I try and use it as normal user (gordon) it complains.
>I have inserted the user gordon into the mysql database and it has all privs
>but it still has the problem.

What did the GRANT statement look like that you used for this?

>I can not even create a database as the user gordon.
>I have started the safe_mysql & as the unix user gordon but this does not
>seam to help

The UNIX user gordon and the MySQL user gordon are distinct and have
nothing to do with each other, so this won't help.

>Can someone please help me?

We'd have to see the GRANT statement.

Paul DuBois, paul@stripped
User privs in mysqlGordon Stewart27 May
  • Re: User privs in mysqlRolf Hopkins28 May
  • Re: User privs in mysqlPaul DuBois28 May