Re: Create new user in MySQL

You should issue the GRANT first - before you attempt to connect to the database.

The MySQL user authentication is actually managed in the mysql database - e.g. your list of users is in mysql.user.

Note that if you manipulate the mysql.* tables the changes do not take effect until you issue a reload.

Regards,

Jeff

Comment on Re: Create new user in MySQL

Replies are listed 'Best First'.
Re: Re: Create new user in MySQL by gmishra (Sexton) on Mar 27, 2004 at 05:17 UTC
hey thanks. But i need a database handle($dbh) to run the "grant" right? how dow do i make the handle.. unless i connect. Also, what is "reload"? Please help. I am very new in this area. waiting, gauravi	[reply]
Re: Re: Re: Create new user in MySQL by jaa (Friar) on Apr 01, 2004 at 14:07 UTC
Use the $drh handle that you already have to issue the GRANT. If you use GRANT you dont need to worry about RELOAD You should look over the documentation at www.mysql.com/documentation/index.html esp the section on setting up users http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Adding_users Regards, Jeff	[reply]
Re: Re: Re: Re: Create new user in MySQL by gmishra (Sexton) on Apr 08, 2004 at 04:25 UTC
Thanks so much. Gauravi	[reply]