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!!
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!!
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
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.
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.
Bookmarks