Adding Users To Databases Using Phpmyadmin

[Amezis 0]

I am running my own apache server with PHP and MySQL, with phpMyAdmin on my own computer, to test things locally. I know how to create databases and how to create users, but how can I add a user to a database?

[leiaah 0]

MySQL has a default database called mysql which contains the table user where users with different access privileges are stored. To add users in the user table with privileges, login to mysql using your root account and type the following:

 

GRANT privileges   ON databasename.tablenameTO usernameIdentified by 'password';example:GRANT SELECT, INSERT     [I]//or GRANT ALL to grant all privileges[/I]ON DB1.*TO AMEZIS IDENTIFIED BY 'PIZZA';

I hope this helped.

[ernad 0]

and i will explain you:1st: On index page of phpmyadmin find link: Privileges2st: On page Privileges you have user list click on edit user privileges.3th: On page find Database-specific privileges select from list database and press go that is all...

[iGuest 3]

Bad Request while dumping sql queries in PhpMyAdmin 2.11.0 on FedoraAdding Users To Databases Using Phpmyadmin

Hello Everyone, Hope You all doing well,

here I got stuck with one issue in phpMyadmin while creating database table for Joomla customized website. Error showing like this-:

Bad Request

Your browser sent a request that this server could not understand.

 Thanks in advance 

-reply by Pavanesh