[Phpmyadmin-devel] How to create user in mySQL ?
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
participants (2)
-
Manisha -
Marc Delisle