MySQL Users

Create a MySQL User account

Just click the link "MySQL Users" in the left menu of the Virtual Desktop. First, you will only see one link : "Create a new MySQL user account"
Click this link.

Fill the form for the user "toto".

• His username will always be your AlternC account then an underscore (_) then the account name.
• Of course, his password will be different than your main MySQL Account and main database.
  Validate by clicking the button [Create this new user].

Now you can see this new account in the MySQL users list.

Granting access to your databases to a MySQL user

At the moment, this new user has no right to any database. Let’s grant him some rights, for example on the database named demo_spip. To do so, click the link "rights" on the right of this username.

Choose which rights you want to give him, and check the checkboxes, then validate using the [Apply] button.

Now toto will have some rights on the database demo_spip. He is now able to access this database from his php code, or using PHPMyAdmin, which used to be installed with AlternC from this web address : http://servername.tld/admin/sql
For more information, see the chapter on PHPMyAdmin.

You can also delete a MySQL user account from here: just check his name and click the deletion button (a confirmation dialog will appear)