Right of access to database in basic network

[Harding]

hello!

I have a database that I would like the other user can have certain rights! Knowing that other users can be found on the network! they can able to write in the table?

thank you!!

[Zecho]

To allow other users to add, delete or update tables in a database to a MySQL server that is local or remote must configure drots users.

To do this you have more tools.

phpmyadmin:
This convenient tool allows you to configurere the MySQL database via a Web interface. It is available with the following Wamp or EasyPhp.
In the interface, you choose privileges and you add a user on a basis giving rights (checkbox). You valid and when you connect to the server from a remote, you pass the login and password that you entered in the settings for connecting to server

[MindSpace]

hi,
You have to go through the console. To do this, it is to locate your server mysql (mysql.exe in your case) and enter the following line:
<username> mysql-u [-p] if access to the database is password protected for the user.
Once connected you tapes:
<nom_de_la_base> use to select the database in which you want to work.

[Praetor]

you can also go through the user create directly attacking see table mysql.user by inserting the record you want to add.
Just one thing to add a user you must be logged in with a user permission to do so. By default, the only authority to make this kind of operation is root.

Well, I hope I answered your question.