To prevent mysql from starting on boot:
- Open the terminal: Ctrl+Alt+T
- Open the mysql.conf file:
- Comment out the “start on” line near the top of the file, the “start on” might be spread across two lines, so comment out both. (comment adding
# at the beginning)
If you want to manually start mysql, use the following command:
service mysql start
Step 1: Find the
config.inc.php file located in the phpmyadmin directory. In my case it is located here:
Note: phymyadmin3.4.5 folder name is different in different version of wamp
Step 2: Find the line with
$cfg['UploadDir'] on it and update it to:
$cfg['UploadDir'] = 'upload';
Step 3: Create a directory called ‘upload’ within the phpmyadmin directory.
Step 4: Copy and paste the large sql file into upload directory which you want importing to phymyadmin
Step 5: Select sql file from drop down list from phymyadmin to import.
sumber copas dari :
http://stackoverflow.com/a/20264467 (php.ini dan my.ini)
If even after repeated upload you still get timeout error, pleasechange your settings in
$cfg['ExecTimeLimit'] = 300; to
$cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).
Ketika membuka http://localhost/phymyadmin, tampil :
MySQL said: Documentation
#2002 - No such file or directory
The server is not responding (or the local server's socket is not correctly configured).
Connection for controluser as defined in your configuration failed.
sudo service mysql start
sudo service mysql stop
sudo /opt/lampp/lampp restart
sumber gambar dan prolog artikel:
You already have a version of mySQL installed on this machine that is using port 3306. Go into the most recent
my.ini file and change the port to
3307. Restart the mySQL service and see if it comes up.
caranya ketik di terminal:
sudo ./manager-linux-x64.run (karena pake xampp 64 bit)
keluar panel xampp, pilih mysql, klik menu configure: ganti port ke 3307