Stop mysql from running at boot time?

To prevent mysql from starting on boot:

  1. Open the terminal: Ctrl+Alt+T
  2. Open the mysql.conf file: nano /etc/init/mysql.conf
  3. 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

sumber: http://askubuntu.com/a/57382

Advertisements

How to Import 1GB .sql file to phpmyadmin

Step 1: Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php 

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.

C:\wamp\apps\phpmyadmin3.2.0.1\upload\

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/23265518

http://stackoverflow.com/a/20264467  (php.ini dan my.ini)

 

UPDATE

How to solve time out in phpmyadmin?

 

If even after repeated upload you still get timeout error, pleasechange your settings in

\phpmyadmin\libraries\config.default.php

from $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).

sumber: http://stackoverflow.com/a/21641325

MySQL said: Documentation #2002 – No such file or directory The server is not respon

Ketika membuka http://localhost/phymyadmin, tampil :

Error

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.

screenshotnya :

bbc5f715bc4f7ef4df78769b92b0eeb256f7536490

solusi saya:

sudo service mysql start

sudo service mysql stop

sudo /opt/lampp/lampp restart

sumber gambar dan prolog artikel:

http://forums.devshed.com/php-development-5/mysql-documentation-2002-file-directory-server-respon-959987.html

PHPMYADMIN not found mysql.sock

I had the same problem when i installed xampp on my system. The mysql server looks for /var/run/mysqld/mysqld.sock but the mysql.sock file was in xampp folder so i used

 find / -name '*.sock'

to find the mysql.sock file and then used

ln -s <the file location> /var/run/mysqld/mysqld.sock

to get a link for the *.sock file then tried mysql and it ran without error. Hope this could solve yours.

Remember to create the directory if it does not exists.

sumber: http://stackoverflow.com/a/19678127

*) Jika tetap tidak menemukan mysql.sock nya :

sudo apt-get install mysql-server  
(jika telah terinstall, maka install ulang)
sudo service mysql stop
sudo /opt/lampp/lampp start
(sampai status mysql running)

*) intinya jangan sampai ada dua mysql jalan berbarengan

sumber: http://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq

xampp MySQL does not start

MySQLsolusinya:

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:

cd /opt/lampp

sudo ./manager-linux-x64.run (karena pake xampp 64 bit)

keluar panel xampp, pilih mysql, klik menu configure: ganti port ke 3307

sumber: http://stackoverflow.com/a/18177185