Secondly, if you want to give the Global privileges including the administrative rights then you can check the Global privileges option too.Īfter giving the privileges, just scroll down and click on the Go button. This will give all permission of your newly created database to the user you have created. Note: If you want to create a Database user without privileges then leave this step and directly click on the GO button.Ĭheck the box given in the front of Grant all privileges on the database. Note: You can also use the Generate button to create strong and some random password. Note: If you want to create a Database user without password or login then just click on the drop box given in front of the Password column and select the No Password option. Password: Assign some password to your Database user which you are creating here.Host name: Select the Local from the dropdown box.In the User name: Give some name to your Database user.In the Add user account section, you need to provide some information about your user. Click on the Privileges option given in the menu of PHPMyAdmin interface. So, in the above step, we successfully have created the Database, now its time to create a user for that. Step 4: Create Database User from PHPMyAdmin to create login a for database This will create a Database from PHPMyAdmin in MySQL or MariaDB. Now give some name to your database and click on the Create button.
0 Comments
Leave a Reply. |