1

Cannot connect to mysql

view story
linux-howto

http://serverfault.com – Recently I have moved the data folder of MySql to the other folder as describe in the my.ini following: [mysqld] port= 3306 socket= "D:/xampp/mysql/mysql.sock" basedir="D:/xampp/mysql" tmpdir="D:/xampp/tmp" datadir="I:/Dropbox/mysql/data" pid_file="mysql.pid" skip-external-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error="mysql_error.log" innodb_force_recovery = 4 innodb_use_sys_malloc = 1 However, I can't start mysql via XAMPP Control (HowTos)

grtyyu's picture
Submitted by grtyyu on 08/20/2012

Stories similar to Cannot connect to mysql

I have installed XAMPP on my Mac. I know that XAMPP is tuned for very slow desktop and as I have almost 3 million records which I need to join. I have to change something. My tables are MyISAM. As everybody suggests I should have a look at key_buffer_size. However, I'm not sure if my configuration is correct.

I have got a error message with my MySQL server. Linux with 8 GB memory.

/etc/my.cnf optimization 23 weeks 6 hours ago

Hello,

We have websites that are mainly php/mysql driven and website is getting good amount of traffic.

Please suggest changes to improve the performance.

Server Spec is:

Intel Xeon CPU E3-1230 V2 @ 3.30GHz with 8GB of Ram

Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_allowed_packet=100M thread_stack=3M max_connections=600 max_user_connections=50 ft_min_word

I've changed data directory in /etc/my.cnf.

I'm rather new to PHP and xampp.

I have a computer that has installed MySQL server and MySQL workbench as I was working with Java and NetBeans. Now I want to use my computer for developing PHP and other web stuff too.

I installed xampp successfully.

I have the following problem: I cant get etherpad running, when my firewall rules are active.

My firewall: http://pastebin.com/82APzKhi

telnet localhost 3306 gives connection timeout

ps aux | grep mysql:

root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ?

I'm new user of ubuntu 11.10 .

XAMPP mysql error? 39 weeks 2 days ago

I face this problem :

root@aadel-pc:/home/osama# /opt/lampp/lampp startmysql XAMPP: Another MySQL daemon is already running.

I've tried to install phpmyadmin, mysql and apache2 manually before I've install XAMPP, but I've already removed them now.

I don't know how to shut this "other MySQL daemon" ?!

I used this guide to get started and this wiki page as a reference for the upstart script.

My problem is that when I do a service mysql start I get six processes instead of two, as if upstart ran three times.