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? --JoeOn 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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- Joe Stump - [EMAIL PROTECTED] "Software never has bugs. It just develops random features."
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- Joe Stump - [EMAIL PROTECTED] "Software never has bugs. It just develops random features."
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php