MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

30
votes
8answers
52k views

How can I copy MySQL users table from one server to another?

I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away). Would it work to just do a dump of ...
1
vote
2answers
209 views

Uninstall Mysql 5.7 from Ubuntu 16.04

I am having problems with mysql 5.7 in ubuntu 16.04 when it comes to giving users privileges, so I want to re-install it again but when I type the command for removing mysql I get the following ...
0
votes
0answers
10 views

MYSQL Database Crashes

My MYSQL DB Crashes from time to time, and I don´t know why exactly. I was reading the logfile from var/log/mysql. 2016-05-25 08:05:42 1160 [Warning] Using unique option prefix myisam-recover instead ...
0
votes
0answers
14 views

MySQL Replication Errno1146 Table doesn't exist

Here's the setup: I have a MySQL DB cluster in Rackspace that I'm already using for replication to multple slaves in multiple datacenters. I am trying to use AWS' Aurora with a MySQL front-end, which ...
0
votes
0answers
8 views

Connection failed: php_network_getaddresses: gethostbyname failed. errno=0

I need you'r help please... I created php web site in google engine. I open connection to mysql server using appharbor. When i run it local it connect very good and there was no errors in my web ...
0
votes
0answers
5 views

Unable to connect to locally ran SQL DB in Docker Container

I have a mariadb (mysql) running in a docker container with a test db, table and dummy data. I very it's running with docker exec fcd12bf1da81 /etc/init.d/mysql status and it outputs the uptime, ...
0
votes
0answers
24 views

Is there a simpler way to manage this Private Tuition classes' system? [on hold]

I'm making a website for a private tuition classes. Here, the concept is that a teacher goes to teach to the student's house. There are many teachers operating this way teaching many students at their ...
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] ...
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
44 views

RDS Performance slow compared to local mysql install

I have a RDS server (rd3.medium) on AWS that is running basic configuration. I'm trying to run this query, which runs in a few milliseconds on my local computer, as well as a basic web server where I ...
1
vote
0answers
14 views

Inconsistent CPU load on debian

This server runs Apache2, Tomcat6 and MySQL.(if that makes any difference you tell me :) Using htop i can see the cpu load on each of the 4 cores. What I do not understand is witch processes are ...
0
votes
1answer
25 views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
0
votes
0answers
14 views

postfix dovecot, lda(admin@domain.ltd) Error: user admin@domain.ltd: Couldn't drop privileges: Mail access for users with UID 150 not permitted

i install postfix, dovecot, mysql on Ubuntu 12.04. and.. see https://www.exratione.com/2012/05/a-mailserver-on-ubuntu-1204-postfix-dovecot-mysql/ by the way.. omg a error. temporary failure. ...
4
votes
3answers
5k views

MySQL won't start after setting external bind-address

I want to enable remote access to my MySQL server so I've set the bind-address option under [mysqld], which looks like: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql ...
13
votes
4answers
54k views

RSA certificate configured for SERVER does NOT include an ID which matches the server name

I recently started a LAMP server (all the latest versions) w/ WordPress on it, and I'm trying to install a SSL certificate that I recently purchased. When I restart apachectl, error_log gives me this: ...
1
vote
1answer
660 views

Mysqldump not working with SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER privileges

My system: CentOS 6.5 + MySQL 5.6 I have created a backupuser for mysqldump: CREATE USER 'usr_backup'@'localhost' IDENTIFIED BY 'XXX'; GRANT USAGE ON *.* TO 'usr_backup'@'localhost' IDENTIFIED BY ...
7
votes
3answers
4k views

How to fetch ./configure parameters used at last time?

I am upgrading LAMP stack on customer's server and need to ./configure mysql and apache with exact last settings they were compiled with last time. Where do I get these? PHP configure string can be ...
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 ...
-1
votes
0answers
25 views

Is it possible to restore mysql database from frm myi and myd files only?

I accidentally deleted my database while testing mysql work bench.as its a relatively new db on a new server I had no back up running. Luckily I can see some frm, myi ,and myd files. afaik i had ...
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
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 ...
0
votes
1answer
31 views

shell script for geting mysql user grants details

I am trying to get mysql user grant details and echo it to out file hari=mysql -sN -e "show grants for mysqladm"; echo $hari GRANT ALL PRIVILEGES ON *prod_server_list.txt stage_server_list.txt ...
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 ...
0
votes
1answer
10 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D ...
0
votes
1answer
25 views

php unable to connect to MySQL via SSH tunnel

I have executed both commands via SSH with no error and than when I try to connect to the MySQL server via SSH tunnel I get no results even if I do a simple query like select * from table. I get no ...
0
votes
1answer
18 views

Windows server 2012 IIS 8 php data post upload failure to mysql

I'm getting a php data upload fail when attempting to transfer data up to a mysql database from a html5/webgl built app off of Unity. All of the data downloads work regardless of the upload issue. The ...
0
votes
0answers
59 views

Getting “Can't create/write to file '/var/lib/mysql/is_writable'” using docker (inside vagrant on OS X)

I am trying to use docker-compose/docker inside a vagrant machine hosted on OS X. Running 'docker-compose up' always fails with mysqld: Can't create/write to file '/var/lib/mysql/is_writable' ...
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
43 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 ...
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 ...
9
votes
3answers
33k views

MySQL warning “IP address could not be resolved”

I've got MySQL Master/Slave setup and I've noticed the following warnings in the mysql log files on both servers: [Warning] IP address 'xxx.xxx.xxx.xxx' could not be resolved: Name or service not ...
0
votes
0answers
37 views

MariaDB 10.1.x Online DDL spaming error log files

Since our upgrade to a new mariadb/mysql version (previously the 10.0.x branch) we have tons of this messages in our error log. All of them are a type [note] messages but i cannot find any ...
3
votes
3answers
3k views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
0
votes
4answers
1k views

Check if remote mysql is running

I want a bash shell script that i can run using a cron job to check if mysql on a remote server is running. If it is, then do nothing, other start the server. The cronjob will be checking the remote ...
1
vote
1answer
17 views

AWS RDS host instance creation fails: “hardware error”

I'm trying to create a MySQL RDS host instance on AWS (via Ansible) and getting the following error: The database instance has been put into STORAGE_FAILURE due to a hardware failure It happens ...
0
votes
0answers
12 views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

I installed MySql and when i try to start it , it stop with error 3534 here is my error from log 2016-05-19T19:29:20.416636Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table ...
0
votes
2answers
93 views

How to detect slow code or plugin

I don't have much experience with WordPress and I don't know where to start. There is a website which is running very very slow. The hosting company helped me to detect that it's because some piece of ...
1
vote
0answers
25 views

MariaDB ignores root password completely

I just installed MariaDB (mysqld) on a fresh Ubuntu downloaded yesterday. Then I ran the script /usr/bin/mysql_secure_installation and set new root password and disabled passwordless login. However ...
1
vote
3answers
115 views

AWS WordPress site - OOM kills Apache

This question was originally asked on StackOverflow.com, and I've duplicated it to the more appropriate ServerFault.com site. The original question, which I've voted to close, can be found here I ...
9
votes
3answers
19k 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
1answer
2k 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 ...
1
vote
1answer
5k 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 ...
2
votes
3answers
1k views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
0answers
12 views

How to overload package_name in Chef cookbook using AWS custom JSON?

I never worked with Chef and OpsWorks before. What I'm doing, I'm trying to overwrite some Chef conf to use modern PHP 5.6. I wrote a JSON for Layer PHP App Server { "mod_php5_apache2": { ...
0
votes
1answer
57 views

Nginx php5-fpm varnish taking high CPU. Load average is over 32

I'm on a server with the following config: 32 GB RAM 12 core processor and it's running single wordpress on nginx, varnish, php5-fpm, fastcgi. Everything was running fine, but suddenly after ...
0
votes
0answers
13 views

MySQL's console client does not display non-latin symbols

I have installed mysql 5.6 on debian 5.10 from official mysql deb repository: deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 So i have these packages installed: # dpkg -l | grep mysql | ...
23
votes
5answers
59k views

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it: ╰$ sudo service mysql restart stop: Unknown ...
0
votes
1answer
30 views

Fix PHP error Invalid argument supplied for foreach() after update PHP & Mysql

I have updated PHP from 5.3 version to PHP 5.6.21 (mod_fcgid) on my CentOs 6.5 vps. The vps holds 4 Prestashop and almost works but cart doesn't work as expected. The php error log contains this ...
0
votes
0answers
22 views

InnoDB table takes more than 1 second for insert query

during an insertion it takes about an second for sometimes (not always) in MySQL 5.6.17-log which is causing performance issue How to over come this issue current set of parameters for innodb ...
-1
votes
0answers
36 views

MYSQL very slow on a huge server

I have an ecommerce with a lot of products (more than 100K). And around 2000 visits every day. My Database is very slow, but I have a huge server (for this amount of visits). Server: 16GB Memory ...