It’s either a spelling error. Simply check the names again. or the PHP code and PHPMyAdmin are connecting to different databases The latter could happen, for example, if you have multiple database servers on your PC installed. To get a proof, run the following query in phpmyadmin: show databases; And then run the same query … Read more
I faced the same problem. Check your mySQL version: For mySQL 5.5, use phpMyAdmin 4.4.x and above For mySQL 5.1, use phpMyAdmin 4.0.x Hope this helps someone.
Okay, so i tried all of the answers and none of them worked. If you are using different port than 3306 for MySQL you need to specify it in config.inc.php. So since i was using port 3308, my solution was adding the following line in config.inc.php: $cfg[‘Servers’][$i][‘port’] = 3308; add it right bellow the user, … Read more
Per the mySQL documentation you should be able to set up a foreign key mapping to composites, which will require you to create the multiple columns. Add the columns and put this in your group table FOREIGN KEY (`beggingTime`,`day`,`tutorId`) REFERENCES tutorial(`beggingTime`,`day`,`tutorId`) As Steven has alluded to in the below comments, you SHOULD try to re-architect … Read more
Use a shell script like this: #!/usr/bin/env bash cd yourdirectory for f in *.csv do mysql -e “USE yourDatabase LOAD DATA LOCAL INFILE ‘”$f”‘INTO TABLE yourtable” done
A better solution here is to change the config that controls phpMyAdmin and not the php.ini file. If you change the php.ini file you effect everything in PHP and should you write that infinite loop that we all do from time to time it will take longer to terminate your infinite loop than is sensible. … Read more
Changing php.ini will change the session duration for all the websites running on the server. To change it just for PhpMyAdmin, open config.inc.php and add: $sessionDuration = 60*60*24*7; // 60*60*24*7 = one week ini_set(‘session.gc_maxlifetime’, $sessionDuration); $cfg[‘LoginCookieValidity’] = $sessionDuration;
I had this problem after changing the password for the root user in phpMyAdmin. I know nothing about programming but I solved it by doing the following: Go to file C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php (I guess you would replace “wamp” with the name of your server if you’re not using Wamp Server) Find the line $cfg[‘Servers’][$i][‘password’]=” and change … Read more
To change the language that MySQL uses when reporting you need to change the my.ini file as follows. Find this line: # Change your locale here ! lc-messages=fr_FR And change it to your prefered language, for example: lc-messages=en_GB To change it to English US, you can do like this: lc-messages=en_US Save the file and then … Read more
If you’re getting the #2002 Cannot log in to the MySQL server error while logging in to phpmyadmin, try editing phpmyadmin/config.inc.php and change: $cfg[‘Servers’][$i][‘host’] = ‘localhost’; to: $cfg[‘Servers’][$i][‘host’] = ‘127.0.0.1’; Solution from Ryan’s blog Edit (20-Mar-2015): Note that if you’re on a fresh install, config.inc.php may not exist. You need to rename / copy config.sample.inc.php … Read more