Open phpMyAdmin in a browser and log in as root. Create a database called phpmyadmin Create a user called pma and set the “host” to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full … Read more
Find config.inc file under C:\wamp\apps\phpmyadmin3.5.1 Inside this file find this one line and replace it with
PhpMyAdmin error on MacOS. I want answer I really have no idea what I need to do to resolve this.
I once had this problem and solved it by installing mysql-server, so make sure that you have installed the mysql-server, not the mysql-client or something else. That error means the file /var/run/mysqld/mysqld.sock doesn’t exists, if you didn’t install mysql-server, then the file would not exist. So in that case, install it with But if the mysql-server is already installed and is running, then you … Read more
You need to follow the following steps: Find line that read follows Replace with your workstation IP address: Again find the following line: Replace as follows: Also find deny from all and comment it in the entire file. Save and close the file.Restart Apache httpd server: Edit: Since this is the selected answer and gets best visibility … Read more
Actually, that’s only a “secret string” like “my personal secret”. Look here.
If you want to use phpMyAdmin to set up relations, you have to do 2 things. First of all, you have to define an index on the foreign key column in the referring table (so foo_bar.foo_id, in your case). Then, go to relation view (in the referring table) and select the referred column (so in … Read more
change localhost to 127.0.0.1 in /etc/phpmyadmin/config.inc.php The reason for this is that pma tries to connect to the mysql.socket if you use localhost. If you use 127.0.0.1 PMA makes a TCP connection which should work.
I have a problem running phpMyAdmin. When I try to access phpMyAdmin in my browser, I get the error message: “The mbstring extension is missing. Please check your PHP configuration.” I have already searched on the internet for possible solutions. According to that, I made some modifications in php.ini file. I uncommented the line “;extension=php_mbstring.dll” … Read more
I am unable to connect to my MySQL in xampp I have this error: MySQL said: Documentation 1045 – Access denied for user ‘root’@’localhost’ (using password: NO) mysqli_real_connect(): (HY000/1045): Access denied for user ‘root’@’localhost’ (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the … Read more