I have scoured Google trying to discover how to do this, but essentially I want to connect to a colleague’s MySQL database for working together on a WordPress installation. I am having no luck and keep getting an error about the connection not being possible: Unable to connect to any of the specified MySQL hosts.MySql.Data.MySqlClient.MySqlException (0×80004005): Unable to connect to any of the specified MySQL hosts. at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() [...]

I am trying to setup HAProxy with MySQL failover with Ubuntu. I used a setup similar to this serverfault question, however I am getting the following error when starting haproxy: [ALERT] 341/220001 (17405) : parsing [/etc/haproxy/haproxy.cfg:29] : unknown option ‘mysql-check’. [ALERT] 341/220001 (17405) : Error(s) found in configuration file : /etc/haproxy/haproxy.cfg [ALERT] 341/220001 (17405) : Fatal errors found in configuration. I even tried installing the lastest version of HAProxy (1.4.22). Does anyone know how to [...]

I’m trying to install GDAL on my CentOS server to be able to make some GIS operations, but I’m having a lot of problems with MySQL that I can’t figure out… Here are the commands I tried, without success. I tried a simple: # yum install gdal First, the GDAL version is 1.4 (the last released one is 1.9) Then, I see in the dependencies list mysql. But I have mysql already installed, from another [...]

I tried adding lines to my.cnf [mysql] infile = 1 [mysqld] infile = 1 SHOW VARIABLES LIKE “%infile” displays true in mysql. But LOAD DATA does not work. I tried it in a PHP script and in phpMyAdmin. It only works if I start mysql from the command line with the –allow-infile flag mysql –local-infile -u root -p db_name But this did not solve the PHP problem. Asked by Buttle Butkus I finally solved the [...]

Here’s the scenario. We create a campaign in our database of email addresses ( around 200K emails per campaign). We send 4 such campaigns (newsletters) daily. The emails are such that a lot of users will come to the site as soon as they receive the email. So, even before our campaign has finished, the load on the server gets double high because users have already started clicking. The campaign sending cron job and receiving [...]

How can I fix this and start mysql-server? After /etc/init.d/mysql start or service mysql start I get the message start: “Job failed to start” And after # mysqld I get this: mysqld 121123 11:33:33 [ERROR] Can’t find messagefile ‘/usr/share/mysql/errmsg.sys’ 121123 11:33:33 [Note] Plugin ‘FEDERATED’ is disabled. mysqld: Unknown error 1146 121123 11:33:33 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it. 121123 11:33:33 InnoDB: The InnoDB memory heap is disabled 121123 11:33:33 [...]

Our company is using TokuDB on production and we are having a lot of problems trying to mitigate lag on our slave. Is very strange, because we’re talking about very few rows… but with a few data it gets lagged. Slave is a read-only DB. For more information, we are using: CPU: Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz (4 cores) RAM: 16Gb HDD: 2Tb ST2000DM001 (EXT4 filesystem) Here you can see some I/O performance outputs. [...]

Every time I restart MySQL server bitnami@xxx:/$ sudo opt/bitnami/ctlscript.sh start server   WWarning: World-writable config file ‘/opt/bitnami/mysql/my.cnf’ is ignored Warning: World-writable config file ‘/opt/bitnami/mysql/my.cnf’ is ignored 121120 12:30:18 mysqld_safe Logging to ‘/opt/bitnami/mysql/data/mysqld.log’. 121120 12:30:18 mysqld_safe Starting mysqld daemon with databases from /opt/bitnami/mysql/data 121120 12:30:20 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-136-14-170.pid ended /opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started The server responds with the following error: (2002, “Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [...]

I am having an issue on OS X 10.7.5 as I used to use MAMP but for .htaccess issues I am now using my own compiled local server from a long time ago, the problem is i forgot the root password for mysql. I have tried updating the password through terminal using mysql -u root, but I get this error message -> ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO) Asked by [...]

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can’t figure out how can I implement if for 3 different MySQL Servers. Does anyone know how to accomplish this? Asked by Mahendra You have to set it up as a ring — A is the master for B, B is the master for C, and C is the master [...]