Menu
I am running phpMyAdmin and MySQL on XAMPP for Windows.
I am accessing the MySQL database in two ways. First, via localhost/phpmyadmin, and second, via a connection.php file (with mysql_connect('localhost','user','password') which is used by other php files for a website on the server.
Both for the phpMyAdmin login and the mysql_connect I am using the root user. I know I should not be using root and that it is a security issue. But the passwords differ! I have set the password for the phpMyAdmin access via localhost/security, but I can't figure how to change the password required for the mysql_connect.
I thought it would be the same but apparently it is not. How do I change the root password through phpMyAdmin?
671
Open phpMyAdmin in XAMPP. The phpMyAdmin interface. If you're asked to log in, use the username “root” and enter your root password. If you haven't set one yet, you can leave it blank.
XAMPP is an open source package that is widely used for PHP development. XAMPP contains MariaDB, PHP, and Perl; it provides a graphical interface for SQL (phpMyAdmin), making it easy to maintain data in a relational database. If you have not installed XAMPP, please refer to XAMPP-setup to install and set up XAMPP.
Show activity on this post. You can access that database with the user/password used to login on the phpMyAdmin. You can also create new users (if you have permission to) under the tab Privileges > Add new User. Here you can create pairs of user-database with the same name and auto-permission-granting.
if you open localhost/phpmyadmin you will find a tab called "User accounts". There you can define all your users that can access the mysql database, set their rights and even limit from where they can connect.
185
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
