MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
52 views

Accidentally delete ibdata1, ib_logfile1 and ib_logfile0

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
0
votes
0answers
44 views

nginx + php-fpm: 502 - when mysql is under load

mas :) I've got the following hardware 1 dedicated MySQL server (5.1x) 3 webservers with nginx and php-fpm (Ubuntu 12) and I'm running a small magento shop and several other low-traffic sites on ...
0
votes
0answers
42 views

Diagnosing high Network Out (Bytes) by MySQL instance

I have an EC2 instance (r3.xlarge) with only MySQL running on it. At some points in time, this machine sends a sustained amount of information (at almost a rate of 400Mbps) for about an hour or more ...
5
votes
3answers
17k views

Allow linux root user mysql root access without password

On cPanel when I am logged in as root and type "mysql" without hostname and password it gives me direct access to mysql root user. I would like to do this for one of my non-cpanel server where the ...
0
votes
1answer
33 views

VMware Host only network - Cannot connect to mysql between VMs

I've setup a virtual private network using VMware workstation 11. IPs are configured as so: Host: 192.168.129.1 Physical machine VM: 192.168.129.3 MariaDb database VM: 192.168.129.4 Web ...
8
votes
2answers
7k views

First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges

I've been trying to move an existing db from MySQL running on EC2 to a new Amazon RDS instance (an experiment to see if we can move across). So far, it's not going well. I'm stuck at the initial ...
7
votes
8answers
21k views

MySQL: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist [closed]

All of a sudden my local MySQL 5.5 server stopped running on my Windows XP SP3. I also have WAMP Apache and WAMP MySQL installed, but WAMP MySQL is not running. Error log shows: Can't start ...
1
vote
1answer
29 views

Dovecot error reading mailbox: Can't expand ~/ for mail root

I want to configure dovecot to use mysql as users database. This is my config: # Authentication for SQL users. Included from 10-auth.conf. # # <doc/wiki/AuthDatabase.SQL.txt> passdb { driver ...
1
vote
2answers
31 views

Moving mysql slave

I am trying to move MySQL slave from old pc to new. Original slave is MySQL version 5.6.12 same as new slave(MySQL is part of wamp 2.4). Replication works fine at old machine. But when I stop slave, ...
4
votes
2answers
3k views

MariaDB / MySQL galera cluster nodes won't join

I'm setting up a MariaDB Galera cluster and I can’t seem to get the nodes to join each other. They both start up without errors but never seem to join, the status is always disconnected: MariaDB ...
0
votes
0answers
21 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
0
votes
1answer
21 views

mysql master to master replication with one slave

I have 3 servers Server A master to Server B Server B master to Server A and Server C Server C slave to Server B When I add table to Server A, it replicated on server B but not in Server C When I ...
2
votes
3answers
89 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. I've been receiving tons of high 5 min load average alert ranging ...
0
votes
0answers
31 views

On Cloud: [Warning] IP address '' could not be resolved: Temporary failure in name resolution

I have configured mysql on cloud (azure) and can find lot of unknown IP's which are trying to connect with my db instance. I have configure my db users and bind it with network IP's. How can i stop ...
2
votes
1answer
281 views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist - Trying to run second instance of myslq

On a Win7 box. I downloaded mysql-5.7.9 and I am attempted to run it as its own self contained instance along side another instance of an old version that is already running. I installed a new ...
0
votes
0answers
30 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema TABLES stores the create date of the tables on the column CREATE_TIME. Unfortunately ...
2
votes
2answers
170 views

Accessing Google Cloud SQL through a Google proxy

I'm looking for a way to expose my google cloud sql server (running mysql), to my api servers. I might add/remove them in the future and adding them mysql access is an additional step in ...
3
votes
3answers
2k views

How can I synchronize 2 web server files with load balance?

I need to setup a website with load balance to accommodate more visitors, I've seen on forums that varnish(balance)->apache(web1&2)->mysql(dbserver) is the way to go. I know how to setup ...
1
vote
2answers
26k views

MySQL remote connection - Access denied for user 'username'@'localhost' (using password: YES)

I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server. I added the user by: CREATE USER ...
3
votes
0answers
20 views

MySQL user suddenly loses some permissions [closed]

On CentOS 7, I have a MySQL (actually MariaDB) database user that needs all server privileges from a remote IP (to be able to use Navicat Premium to manage the database). Somehow every once in a ...
6
votes
4answers
4k views

Changing the mysql bind-address within a script

What would be the best way to change the mysql bind-address in the my.cnf from a shell script? Is there a way using a tool like mysqladmin or should I use sed or should I simply append it to the ...
1
vote
4answers
5k views

How to find slave's IP address and user name from Master server?

I am writing a code to extract the ip address and username of slave server in a MySQL replication environment. Does anyone know any function, variable, or something that I can run on the console and ...
3
votes
2answers
2k views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
0
votes
0answers
24 views

Kamailio 4.3 replecing opensips 1.11

We have a customized sip routing script in opensip 1.11 now for good performance and stability we are moving to kamailio 4.3. So here am facing some issues related to kamailio module and funciotns ...
0
votes
1answer
72 views

Package mysql-server-5.6 is not configured yet

I had an issue installing MySQL 5.6 on Ubuntu 15.10. Basically loading the db server failed for the mentioned reason. mysql-server depends on mysql-server-5.6; however: Package mysql-server-5.6 is ...
0
votes
0answers
80 views

mysql won't start after upgrade to 5.6 - Permission denied

I'm running Ubuntu 14. Last week I was trying out some PDF tools locally and while trying to install pdftk it mentioned something about a dependency problem and needing to upgrade my 5.5 install to ...
0
votes
1answer
21 views

How do I install mysqli_ for PHP on Linux without affecting anything else?

I have root access to a server and it is currently running a live e-commerce site with lots of sales. The site currently uses mysql_ for everything. mysqli_ is not installed at all. I need to keep ...
-1
votes
1answer
49 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
1
vote
1answer
44 views

mariadb mysql parallel installation apache and php

I'm trying to install mysql and mariadb on the same server as a parallel installation, each service on a different port. I installed mysql server using apt-get on a debian-based distro and then ...
1
vote
1answer
60 views

MySql on Azure Throwing Pool Connection Timeout Errors

I have 2 Virtual Machines on Azure in the same Virtual Network. One virtual machine runs a NodeJs process which is responsible for MySQL operations. Other virtual machine runs a MySQL instance. I ...
-1
votes
1answer
94 views

YUM attempt to install instead of update MySQL packages

I have a doubt about the difference between install and Upgrade message with YUM Update. I have 2 servers with MySQL 5.6.25 installed on then "Server A" and "Server B". When I run the command: YUM ...
0
votes
0answers
42 views

change file system from ext3 to ext4 effict on MySQL

I have a situation where MySQL was installed in Linux with a ext3 file system. One table (InnoDB) reached the maximum size allowed for ext3 (2 TB) , insert statement gave "The table 'foo' is full". I ...
0
votes
0answers
22 views

Do I need binlogs with a Percona xtradb cluster?

If I am running an XtraDB cluster, with no replication, do I need binlogs? They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if ...
-1
votes
1answer
37 views

Syncing MySQL backup with GIT tags

We have a large Yii2 / PHP application using MySQL database and versioned by GIT. The application is under continuous development as customer require new features. The database gets changed quite ...
0
votes
1answer
16 views

service mysql restart with default options

I have Ubuntu 14.04 with MariaDB Galera cluster installed. My cluster has just one node now, so I restart the mysql service using: sudo service mysql restart --wsrep-new-cluster How can I set this ...
-2
votes
1answer
18 views

Rotate Old Files

I have a cron to backup 3 files every Hour, they are SQL backups - in the format name-name-bak-2015-12-1919:30:01.sql I need a way to rotate and delete the older ones say every 7 days? Thought of ...
0
votes
1answer
23 views

Get password for all failed MySQL logins

Im having issues trying to figure out what is the cause of a failing SQL login. The password seems correct to me, but it still isnt working. I want to see what exactly the user login is sending when ...
0
votes
0answers
7 views

Access denied error connecting to SQL DB with Postfix

I have no idea how to go about debugging this. I have created an SQL user called postfix and i have verified that i can log into the DB with this user and edit tables. I have configured postfix to use ...
0
votes
1answer
79 views

PHPMyAdmin “#2006 - MySQL server has gone away” during login

First: I've searched all over Google and although this looks like an infamous error, none is actually my case and hence no fix is available. OK so today I encountered this something weird: PHPMyAdmin ...
0
votes
0answers
16 views

Need to determine why my VPS rebooted - every few days, a sudden spike

Can anyone give some advice as to why my LAMP VPS server (running centos) reboots every few days? Well I know why - it's because the CPU and load suddenly spikes, but what causes the spike and what ...
0
votes
0answers
24 views

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and ...
0
votes
1answer
34 views

mysql won't start on FreeBSD

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running. There is no mysql ...
-2
votes
1answer
23 views

How can I reduce the Cache usage of MySQL and raise the free memory?

I currently have a virtual server with 12 GB of RAM and 8 CPU running many websites with Apache and MySQL. When looking in PhpMyAdmin monitor, I see the following resource usage graph: image -> ...
3
votes
1answer
70 views

AWS MySQL ERROR 2026 (HY000): SSL connection error:

I' am trying to connect to my AWS RDS MySQL instance with terminal on OSX El Captain, but I keep getting this error: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) ...
22
votes
4answers
14k views

What's a secure alternative to using a MySQL password on the command line?

We have a PHP command-line script to version a database. We run this script whenever a developer has added a new database patch. The script runs the patch with the MySQL command-line: system('mysql ...
4
votes
5answers
1k views

mysqldump for sql server [closed]

I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database. I know sql server ...
2
votes
2answers
2k views

MySQL max_connections on an EC2 m1.large instance

I'm running a dedicated MySQL server on an m1.large EC2 instance, which has 7.5 GB of RAM. What might be a good number to set my max_connections value to?
2
votes
2answers
17k views

How enable pdo_mysql

I am trying to install SpaceBukkit. I was wondering how I enable pdo_mysql. When trying to setup the MySQL part I get this error: The "pdo_mysql" extension is NOT loaded in your `php.ini`! Make sure ...
0
votes
0answers
23 views

High CPU due to MySQL after killing processes

On my linux server I ran into a problem this morning. I realized that after I killed all background tasks that were making ~200k database entries (1gb in size) throughout the night, my CPU usage was ...
-1
votes
1answer
14 views

Cacti and MySQL Queries

I am new to Cacti and am interested in using it to perform some queries against a MySQL database. I have a software which logs an error counter into a MySQL table, and I'd like to be able to graph ...