SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[php] php/mySQL on XAMPP: password for phpMyAdmin and mysql_connect different?

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?

This question is related to php mysql sql phpmyadmin xampp

The answer is

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.

You need to change the password directly in the database because at mysql the users and their profiles are saved in the database.

So there are several ways. At phpMyAdmin you simple go to user admin, choose root and change the password.

Source: Stackoverflow.com

Examples related to php

• I am receiving warning in Facebook Application using PHP SDK • Pass PDO prepared statement to variables • Parse error: syntax error, unexpected [ • Preg_match backtrack error • Removing "http://" from a string • How do I hide the PHP explode delimiter from submitted form results? • Problems with installation of Google App Engine SDK for php in OS X • Laravel 4 with Sentry 2 add user to a group on Registration • php & mysql query not echoing in html with tags? • How do I show a message in the foreach loop?

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to phpmyadmin

• phpMyAdmin on MySQL 8.0 • phpmyadmin - count(): Parameter must be an array or an object that implements Countable • Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?' • phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) • phpMyAdmin access denied for user 'root'@'localhost' (using password: NO) • mysqli_real_connect(): (HY000/2002): No such file or directory • How to create a foreign key in phpmyadmin • #1292 - Incorrect date value: '0000-00-00' • MySQL error - #1932 - Table 'phpmyadmin.pma user config' doesn't exist in engine • phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration

Examples related to xampp

• Xampp localhost/dashboard • phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) • Is there way to use two PHP versions in XAMPP? • Where to find htdocs in XAMPP Mac • phpMyAdmin access denied for user 'root'@'localhost' (using password: NO) • How to downgrade php from 7.1.1 to 5.6 in xampp 7.1.1? • How to turn on/off MySQL strict mode in localhost (xampp)? • mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it • How to install mcrypt extension in xampp • Fatal error: Uncaught Error: Call to undefined function mysql_connect()