Need to access mySQL from command line.

M

morfargekko

Verified User
Joined
Oct 21, 2007
Messages
189
Hi, one of my clients need to have specia rights for a mysql user which according to him isn't included in the rights he can grant when he creates a user in DA, so I was to access mysql from the command line to check what rights a normal user gets when created.

The rights he want his user to have is :
CREATE ROUTINE, ALTER ROUTINE, EXECUTE
Is there any problem giving out such rights?

Now to the problem:
From what I remember when the system was first set up I had no problem accessing mysql from the command line but now it doesn't work and I cant remember what I have done to mess things up.

Is there a HOWTO somewere that can explain what to do in such cases? :confused:
 
Hello, I still have a problem granting a database user the following rights:
CREATE ROUTINE, ALTER ROUTINE, EXECUTE

When I issue the command " GRANT CREATE ROUTINE ON mydatabase.* TO 'mydatabase_user'@'localhost'; " in mysql it seans that it works but it doesnt show when I issue the command " show grants for mydatabase_user;

Am I doing something wrong or what? :confused:
 
You must log in or register to reply here.
Back
Top