[Phpmyadmin-devel] How to create user in mySQL ?

[Marc Delisle]

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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>