Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5.5]

MySQL RDBMS version 5.5

MySQL relational database management system version 5.5

133 questions
71
votes
18 answers

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed Any ideas on where to look for what's happening…
Jim Rubenstein
  • 1,187
  • 1
  • 10
  • 16
18
votes
3 answers

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote MySQL server to use them (and SSL is enabled) I ssh into my remote server, and try connecting to its own mysqld using SSL (MySQL server is 5.5.25).. mysql -u -p --ssl=1…
carpii
  • 521
  • 2
  • 4
  • 12
15
votes
1 answer

All MySQL Databases lost overnight

After a call from a customer to say that his website is down, I find that MySQL on our RackSpace Cloud Windows 2008 server was not running. I restarted MySQL but got the 'Access denied for user' error in the browser for all websites with MySQL…
Iain
  • 151
  • 4
12
votes
3 answers

Slave replication stops with Last_SQL_Errno: 1032

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the following error: Last_SQL_Errno: 1032 …
adminz
  • 397
  • 2
  • 4
  • 19
12
votes
4 answers

Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'

I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do: SET GLOBAL general_log_file = '/var/lib/msyql/ubuntu.log'; I get…
XåpplI'-I0llwlg'I -
  • 271
  • 1
  • 2
  • 7
9
votes
1 answer

Is It key_buffer or key_buffer_size?

I search the internet regarding the correct variable in my.cnf file. Some said that key_buffer_size is deprecated, but some said that key_buffer_size is the correct variable in my.cnf. So, what is really the correct variable here? Is it key_buffer…
jaYPabs
  • 279
  • 1
  • 4
  • 19
7
votes
1 answer

MySQL Slave stuck on a single bin log + bin log position for 17+ hours

tl;dr: Replication is stalled on a specific binlog and position, and I'm not sure why I have a MySQL Replication setup with MySQL 5.5. This replication setup has no history of ever falling behind and has always been solid. This morning, I noticed…
Jim Rubenstein
  • 1,187
  • 1
  • 10
  • 16
7
votes
4 answers

enabling ssl connection from wordpress to mysql

I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic my wordpress version is 4.5.2 and obviusly the code and settings is…
Anadi Misra
  • 527
  • 2
  • 9
  • 22
6
votes
3 answers

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error in your SQL syntax; check the manual that corresponds…
Spacedust
  • 558
  • 5
  • 12
  • 28
6
votes
1 answer

Recover a crashed MySQL master server from the slave

we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server we would like to offer to our users the…
LeonardoC
  • 61
  • 1
  • 2
5
votes
0 answers

Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL

I get these error messages when logging in to phpmyadmin instance Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your…
Anadi Misra
  • 527
  • 2
  • 9
  • 22
4
votes
2 answers

MySQL not releasing temp file descriptors

Since a few days ago, we’ve been experiencing some serious problems with our MySQL installation: MySQL keeps opening temporal files (normal behaviour) but these files are never released. The consequence is that, eventually, the disk space is…
Wakaru44
  • 193
  • 1
  • 9
4
votes
2 answers

MySQL 5.1 vs MySQL 5.5 (5.1 twice as fast)

I recently installed MySQL 5.1 on CentOS 6.2 and had a performance gain over the MySQL 4.1 we are running. So I upgrade the MySQL 5.1 to MySQL 5.5 to see if there was even more of a gain but it actually ran half the speed of the MySQL 5.1 setup. The…
David
  • 295
  • 4
  • 10
3
votes
0 answers

script cannot connect to Mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Mysql server seems working properly and running also i can connect to the database via ssh command, here's the my.cnf file directives: [mysqld] #port=3306 datadir=/home/mysql socket=/home/mysql/mysql.sock user=mysql # Disabling symbolic-links is…
GUI9876
  • 31
  • 2
3
votes
1 answer

OpenShift/MySQL error: lower_case_table_names error when migrating from OS X to OpenShift

Ok, so I have dumped a MySQL 5.x database from an OS X instance, and am having problems importing the database into the OpenShift MySQL 5.5 container. My tables are Camel-case (eg "tblAccounts") but the script is throwing errors like "cannot find…
user1399233
  • 31
  • 1
1
2 3
…
8 9