Re: Want to create mySQL user through phpMyAdmin - Manisha - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe: Want to create mySQL user through...

From	Sent On	Attachments
Manisha	08 Dec 2002 18:20
Joe Stump	08 Dec 2002 18:44
Manisha	08 Dec 2002 19:08
Manisha	08 Dec 2002 19:33
Geetika Tewari	08 Dec 2002 20:08
Paul DuBois	08 Dec 2002 20:20
Geetika Tewari	08 Dec 2002 20:28
Geetika Tewari	09 Dec 2002 16:15

Subject:	Re: Want to create mySQL user through phpMyAdmin
From:	Manisha (mani...@aurica.com)
Date:	12/08/2002 07:33:33 PM
List:	com.mysql.lists.mysql

oh! god! -

Thanks a lot, I have a root access and with that I could create a user directly from command line.

I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but seems not this version)

Thanks once again

Manisha

At 10:21 PM 12/8/02 -0500, Joe Stump wrote:

It's not a phpMyAdmin function. If you can run raw SQL against the DB try running this:

FLUSH PRIVILEGES;

But you'll need to be root. If you have access to the command line you can flush them with mysqladmin. Check out http://www.mysql.com/doc/en/Adding_users.html for more information.

In the future you might want to check the manual and mailing list archives before posting.

--Joe

On Sunday, December 8, 2002, at 10:08 PM, Manisha wrote:

I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do not know how to reload it ? I am not finding any such option on it. Can u please tell me more about it.

Thanks, Manisha

At 09:45 PM 12/8/02 -0500, Joe Stump wrote:

Did you reload the privileges?

--Joe

On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote:

I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program <? $conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock", "manisha", "pass"); echo("before conn a"); if ($conn){ mysql_select_db ("demo"); echo("conn got it"); } ?> but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jstump=aa.a...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php