MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
7 views

Linux init script service - delay until mysql socket is ready

How does one go about delaying a service init script in Linux until the MySQL socket exists? Does the sleep command in a startup script delay the entire boot process, or are init scripts each ...
0
votes
2answers
25 views

MariaDB dying regularly

I've recently switched from MySQL do MariaDB to host WP website. Everything was smooth and I even noticed speed increase (which might be just placebo ;). From then on though MariaDB started dying ...
2
votes
3answers
3k views

MySQL-5.5.10 - Lost connection to MySQL server during query (Both Web Clients and MySQL Slaves)

We've just upgraded our existing MySQL5.1 DB servers to newer (much better) hardware with MySQL 5.5, and things have been going mostly smoothly for almost 6 weeks. Just the last few days, I've ...
-1
votes
2answers
41 views

Removed ib files to make mysql start but now it does not recognize tables

I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database ...
0
votes
1answer
13 views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
0
votes
3answers
2k views

MySQL permissions error when showing databases

I was trying to install homebrew and very very stupidly did this: sudo chown -R $USER /usr/local The Homebrew instructions say to do this and I'm not much of a sysadmin so I took their word for it. ...
0
votes
2answers
3k views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
1
vote
1answer
36 views

How to completely remove volumes/instances from OpenStack Kilo database

We're having some troubles deploying Kilo on a system with 3 controllers and 3 computes, through mirantis fuel 7.0. The problems involve creation and attaching of volumes, specially the ones stored ...
53
votes
4answers
60k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
0
votes
1answer
29 views

When Dealing with Databases on Docker

I've been using docker locally for a while and one of the issues I've had is when, inexplicably, the docker container dies and it takes all the data with it. Obviously, this can not happen in ...
0
votes
0answers
10 views

convert plain text passwords to sha512-crypt in dovecot + postfix's mysql mailbox table

I have an old postfix + dovecot + Roundcube mailserver (mail.domain.Tld). Server clock is loosing time and adjusting it causes dovecot to kill itself, we cannot install more memory, bigger ...
0
votes
3answers
2k views

Xubuntu Desktop 14.04 - service mysql start unknown job

I installed fresh XUbuntu desktop 14.04 (as a dev system) and then lamp server using sudo apt-get install lamp-server^. I can type mysql and mysql console run but if I try service mysql start I got: ...
1
vote
0answers
13 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
1
vote
2answers
1k views

large number of InnoDB tables plus SHOW TABLE STATUS

We've got several hundred InnoDB tables in a database, and we use phpMyAdmin to manage them. Unfortunately, phpMyAdmin does a SHOW TABLE STATUS query whenever the list of tables is shown, and this ...
0
votes
1answer
14 views

importing self signed certificates mysql/mariadb and tomcat how to?

trying to use certs for securing connections between Tomcat 8.x and mysql/mariadb. I'm going to use a self-signed cert. What follows is what i think i should be going and appreciate you to jump in and ...
0
votes
0answers
9 views

Fatal error: Call to undefined method mysqli_stmt::get_result(), Mysqlnd enabled [on hold]

I am getting this error Fatal error: Call to undefined method mysqli_stmt::get_result() only on server. The phpinfo http://gerakas-forest.gr/info.php The Mysqlnd is already installed and working. ...
14
votes
3answers
72k views

How do i find out what my IP Address of my MySQL host is?

I have a free domain running at x10hosting (x10.bz), and I want to find out the IP Address of my MySQL host for it, so I can contact the MySQL database from another host. I've already added that host ...
1
vote
2answers
11k views

phpMyAdmin error #2002 “Cannot log in to the MySQL server”, but works from console

The MySQL service on my CentOS 6.3 server works well. I'm using phpMyAdmin-3.5.8.1 from default repository. I have sites that can connect to the databases and are using them successfully. I can also ...
0
votes
1answer
23 views

Can't mysql_secure_installation a fresh MariaDB on fresh Ubuntu 16.04 LTS

I am trying to run mysql_secure_installation on a fresh install of MariaDB on a fresh Ubuntu 16.04 LTS server. I installed via the exact instructions found here. When prompted for Remove anonymous ...
-1
votes
0answers
9 views

Mysql Dump and exclude a bunch of tables via a wildcard

I've searched and couldn't find a clear answer to go about doing a mysql dump excluding a bunch of tables using a wildcard. I know mysql has the --ignore-table option, but I would have to list out ...
-2
votes
0answers
21 views

MySQL optimization suggestion? [closed]

I have a digital ocean vps with 2gb ram, 40gb ssd, 2x intel xeon 2ghz. My mysql stops at random times. this is my confoguration: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock ...
1
vote
1answer
35 views

MySQL server experiencing high stress/max connections

The Short: We're hitting max connections and seeing very poor performance from MySQL during peak business hours and cannot determine if it is a load problem or a configuration problem. The Long: To ...
1
vote
1answer
15 views

Yum dependency available but not marked for install

I'm trying to install a specific version of MySQL: mysql-community-server-5.6.29-2.el6 on RedHat 6.6. When I run yum install, I get dependency errors, but the dependencies are clearly available. I'm ...
0
votes
0answers
8 views

mysql ndb cluster - Management node and data node go down together

I have an NDB scenario with the following details: Blade 1: VM 1 : Management Node (Active) VM 2 : Data Node VM 3 : SQL Node Blade 2: VM 1 : Management Node VM 2 : Data Node VM 3: SQL Node If ...
0
votes
1answer
1k views

Apache not loading: libmysqlclient.so.18: file too short

I have installed MySQL and PHP, and I tried restarting apache and here what happens when I run # service httpd restart: Stopping httpd: [FAILED] ...
1
vote
2answers
69 views

Failed to start MariaDB database server

Since / partition is only 50G, and my data is larger than that. And there are 500G space in /home. So, I move all the data of MySQL into /home. The following are my steps(under root account): shout ...
-1
votes
0answers
19 views

Beginner explanation on MySQL cluster? [closed]

I am a beginner on MySQL and so far I have a web application with only one MySQL server running. I want to add more MySQL servers and started to read about MySQL clustering, but have a problem with ...
0
votes
1answer
19 views

php-cgi.exe CPU load jumps after MySQL Backup

I'm running Windows 2012r2 on a new server, with Plesk 12.5 and MySQL 5.6 installed. There's a backup script which takes a DB dump and zips website data files that runs each day. However, it brings ...
0
votes
1answer
3k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
2
votes
1answer
1k views

Ubuntu upgrade from 14.04 LTS to 16.04 failed - mysql-server-5.7 dependecies fail

I am trying to upgrade existing Ubuntu 14.04 LTS to Ubuntu 16.04 LTS and it seems I am stuck somewhere in the middle. When I turn on my workstation, I get Ubuntu 16.04 LTS welcome & login screen, ...
0
votes
1answer
47 views

How to tune MySQL server when big peak of usage is expected

I'm having pretty big issues trying to tune my MySQL server. I was expecting a lot of people on my website after buying a tv ads between 5pm and 6pm, I have more or less 300 persons at the time on the ...
0
votes
2answers
1k views

'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm getting 'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' error when I'm trying to make too much update and ...
0
votes
1answer
48 views

mysql_upgrade - ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

After backing up my Plesk (12.5.30) server, I received the following error: Not all the data was backed up into /var/lib/psa/dumps/domains/example.com/databases/example_database_1 successfully. ...
2
votes
3answers
25 views

How to escape a - in a table name in mysqldump

If I want to exclude a table in a schema which contains a minus -, how do I escape that in mysqldump? Or do I not need to? mysqldump --ignore-table=foo-bar.tl_log does not seem to work
0
votes
0answers
24 views

MySQL entry is missing from website [closed]

I have a Ubuntu server that runs a bug tracking app called TheBugGenie. This application uses MySQL to store all of the bugs and projects we are working on. The other day, one of the bugs went ...
0
votes
2answers
11k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
1
vote
2answers
2k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
3
votes
1answer
1k views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
15
votes
1answer
6k views

Constantly have to reload PHP-FPM

We have a fairly heavily loaded server running nginx and PHP-FPM. We have 6 websites on this server, running PHP-FPM and nginx. Software is all vBulletin 3.8 and WordPress. Databases are on a separate ...
0
votes
1answer
20 views

Debian Jessie mySQL 5.5 upgrade to testing 5.6 issues?

I need to upgrade from stable mysql-server5.5.x to 5.6.x on Debian Jessie to run Magneto, but I am also running a high volume forum on 5.5.x. If I enable testing repos and pull 5.6.x (currently ...
9
votes
3answers
18k views

Changing host permissions for MySQL users

I have the following grants for a user/database mysql> SHOW GRANTS FOR 'username'@'localhost'; +---------------------------------------------------------------------------+ | Grants for ...
0
votes
0answers
32 views

MySQL server is unreachable from OpenVZ container

Writing out of despair. Yesterday, as usual and having done this for thousands of times before, I'd installed MySQL server in the Head Node for using it from the OpenVZ container. I've created user, ...
0
votes
0answers
23 views

Zabbix Can't Connect to MySQL

I just install zabbix-server on my server with MySQL running on it. I follow step from official website. And finished well. Then i try to access its page using http://my-server-IP/zabbix but it shows ...
0
votes
1answer
1k views

Lost connection to MySQL server during query

I am trying to import our old database into a new databsae on our test server however I keep coming accross this error: "Lost connection to MySQL server during query". As you can see below I have ...
0
votes
2answers
1k views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
1
vote
1answer
17 views
1
vote
1answer
12 views

How to exclude specific table from innodb buffer pool?

Here's my situation. I have one really large table that holds about 90 GB of data. I've utilized DATA DIRECTORY to place that table on another drive, as I rarely use the table and don't want it ...
1
vote
1answer
4k views

Yum: php55w-common conflicts with php-common-5.4

I am trying to install mysqli on a CentOS machine using yum install php-mysqlnd.x86_64 on the command line but I keep getting the message: Error: php55w-common conflicts with ...
7
votes
8answers
2k views

Preventing brute-force attacks on MySQL?

I need to turn on networking for MySQLd, but every time I do, the server gets brute-forced into oblivion. Some mean password guessing script starts hammering on the server, opening a connection on ...