PHP and MySQL

Hello,


While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access levels for them in MySQL?

Secondly, if a website does not offer PHP Admin, how can I use a database I created in phpMyAdmin on my PC for that website?

Thank in Advance

 

in phpmyadmin there is a menu called "Rights" or s.th like that. There u can add and modify the Database users. If your server doesnt come with phpmyadmin you can install it if u have access to the console.

 

PHPMyAdmin is only a ease tool for easily accessing MySQL through a GUI, so your database doesn't require it in any way.

 

You'll need access to the mysql command line utility (http://www.techotopia.com/index.php/The_mysql_Command-Line_Tool) The built-in help system is pretty good. Also see this : http://dev.mysql.com/doc/refman/5.1/en/adding-users.html . Of course, you'll need shell access, normally ssh.

 

you can use sqlyog or other free tool to manage your mysql database, phpmyadmin just one of them,

 

Use phpMyAdmin to export the database on your computer. Upload the exported file to the site. Use whatever tool the site gives you to import the file to MySQL.