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
Try username = root and password is blank.
AMPP by default uses http://localhost/phpmyadmin It also requires you start both Apache and MySQL from the control panel (or as a service). In the XAMPP Control Panel, clicking [ Admin ] on the MySQL line will open your default browser at the configured URL for the phpMyAdmin application. If you get a phpMyAdmin error stating “Cannot … Read more