I want to create mySQL user through 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
Manisha wrote:
I want to create mySQL user through phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table,
A better way to create the user would be to use the User management page in phpMyAdmin: click on Home, then on Users.
Don't forget to reload the MySQL server (there is a link that does that in phpMyAdmin)
You can test the newly created user by a login with this user in phpMyAdmin (using http or cookie auth mode).
About your script, try removing the @ before mysql_connect to see error messages.
And please next time, use the forums or the -users mailing list.
Marc
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
This SF.net email is sponsored by: Microsoft Visual Studio.NET comprehensive development tool, built to increase your productivity. Try a free online hosted session at: http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Manisha -
Marc Delisle