In managing your MySQL/MariaDB database, the root account has the highest level of access and can pose risks if not properly managed. By creating a new admin user in phpMyAdmin, you can limit the capabilities of the root account and establish a separate account for administrative tasks.
By implementing this security measure, you will enhance the safety of your database and minimize the risks of unauthorized intrusion attempts. Let’s get started and learn how to create a new admin user in phpMyAdmin to effectively protect your data.
- phpMyAdmin has been installed
- User privileges: root or non-root user with sudo privileges.
- How to Install and Configure phpMyAdmin on Ubuntu with Apache
- How to Disable root Login in phpMyAdmin
- How to Set Up a Static IP Address on Ubuntu Desktop
- How to Upgrade Windows 10 Home to Pro or Any Windows 10 Edition
- How to Install and Configure pfSense Firewall on VMware Workstation
To begin, log in to your MySQL/MariaDB server using the following command:
sudo mysql -uroot -p
In this example, we will create an admin account named totatca with the password totatcaPWD using the following command:
CREATE USER totatca@localhost IDENTIFIED BY
Note: That totatca and totatcaPWD are sample values, and you can replace them with your desired account name and password.
In the next step, grant all privileges on all databases to the user totatca using the following command:
GRANT ALL ON *.* TO totatca@localhost;
Then reload and exit
Finally, to test open phpMyAdmin in a web browser and try login with your account:
You will see that your account is granted management privileges for all databases on your server.
Creating a new admin user in phpMyAdmin is a straightforward process that enables you to manage your MySQL databases effectively. By following the steps outlined in this guide, you can easily create a new admin user with the necessary privileges to administer your databases with confidence.
Thank you for reading !!!