#PHPMYADMIN XAMPP CREATE NEW USER PASSWORD#

Enter database name, select collation (you may leave it to default) and click. To do this:ġ.Click on the “Edit privileges” link next to the username in the “User accounts” tab.Ģ. Select the database(s) you want to grant access to in the “Database” section.ģ. Select the privileges you want to grant to the user in the “Privileges” section.Ĥ. Click the “Go” button at the bottom of the page to save the changes. Example Login using username root and root password. To create a new user account in MySQL, follow these steps: Access command line and enter MySQL server: mysql The script will return this result, which verifies that you are accessing a MySQL server. Once you have created the user, you can grant permissions to the user by selecting the database(s) and the privileges you want to grant to the user.

#PHPMYADMIN XAMPP CREATE NEW USER PASSWORD#

Enter a password for the new user in the “Password” field.Ĩ. Retype the password in the “Re-type” field.ĩ. Leave the “Authentication Plugin” field set to “Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)”.ġ0. Click the “Go” button at the bottom of the page to create the new user.

You can create a MySQL database user in XAMPP by following these steps:ġ. Open XAMPP Control Panel and start the MySQL server.Ģ. Open your web browser and navigate to 3. Click on the “User accounts” tab in the top navigation menu.ĥ. Enter a username for the new user in the “Username” field.Ħ. Select “Local” as the host from the drop-down menu.ħ.

Phpmyadmin xampp create new user