MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

2
votes
1answer
9k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
2k views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
15
votes
2answers
29k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...
1
vote
2answers
1k views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
0
votes
1answer
1k views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...
2
votes
2answers
172 views

MySQL doesn't start after upgrading to Debian Jessie

I have a server with Proxmox 3.4 with several OpenVZ-containers. Host and all guests are running Debian 7 x64. Now I want to migrate my old setup to a new server with Proxmox 4 (based on Debian 8). I ...
0
votes
2answers
53 views

MySQL stopped running on Ubuntu: Can't change to run as user 'mysql'. How to save data?

Today out of the blue stopped running MySQL on a Ubuntu server. When I try to log in there, I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
16 views

mysqldump --databases option vs .my.cnf inconsistency

I had an issue which another serverfault issue solved, however, I'm trying to understand WHY. This issue is here: Mysqldump complains about chosen databases regardless of command line, and the ...
0
votes
3answers
1k views

MySQL Tables crashing randomly

This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this? How do I keep MySQL tables from crashing and MySQL from crashing? Repairing USR_wp537 ...
32
votes
1answer
77k views

How do I change the privileges for MySQL user that is already created?

I understand how to create a new user with privileges, but what is the correct way to change privileges for users that are already created? We are running a DB audit and some of the users have way ...
1
vote
1answer
1k views

Issue with aborted MySQL connections (error code: 4)

Some of the connections between my application server (Ubuntu, Apache, PHP) and my DB server (Ubuntu, MySQL) are failing with error code 4. According to the documentation error code 4 is: OS error ...
1
vote
1answer
3k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
0
votes
0answers
12 views

MySQL not creating tables automatically when JAMES APACHE is started

The programs I am using: JAMES Apache Server 2.3.1 binary MySQL Workbench 6.1 CE MySQL Connector 5.1.38-bin.jar in ~/james/lib OS: Windows 10 64-bit In james 3, I am able to create MySQL ...
0
votes
1answer
41 views

Windows server 2008 R2(standard) client connection is very slow after connecting above 24 client machines? Is there any client connection limit?

Windows server 2008 r2 standard is connecting 24 cilent machines after while adding extra machines to server it gets slow. In Windows server 2008 r2 maintaining the mysql database and all other client ...
1
vote
1answer
39 views

Get mysql last uptime

I just restarted the MySQL service. I know how to get the current Uptime, but by any chance is there a way to get the uptime before last restart ? Thanks
19
votes
4answers
6k views

Why not use a WAMP stack?

I recently had a talk with some experienced people and they suggested to me not to use a WAMP stack, and instead install apache, mysql and php separately. I don't understand why they have suggested ...
1
vote
1answer
103 views

Why does this “netstat -tln” output show entries for “0.0.0.0:22” and “127.0.0.1:3306” [closed]

When I run the command netstat -tln I see the following output: Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 ...
-2
votes
0answers
16 views

Backup mysql databases from ubuntu server into windows laptop scheduled

I have installed webmin to backup mysql server into a directory on /home/serveronit/mysql-backup and it works in my ubuntu. This ubuntu is on 192.168.5.225 This is the list of file ...
1
vote
0answers
29 views

have xmpp (ejabberd) server authenticate with existing user database (MySQL)

Let me start off by stating that I know very little about the XMPP protocol or real-time communication in general. I did however manage to set up an ejabberd server with TLS encryption. I have written ...
0
votes
3answers
34 views

Backing up MySQL MyISAM databases by copying the physical folders

I have a Windows Server 2008 R2 machine and on it I have 2 MySQL MyISAM databases. These databases are quite large as they are over 20GB in combined size. I update these databases once a week. (I ...
0
votes
0answers
14 views

Server auto disabling pdo

PDO mysql plugin wasn't enabled by default in my server , so i added a line extension=pdo_mysql.so to a php.ini file i created, and it works fine , but every once in a while it is ...
2
votes
2answers
1k views

How to Grant Apache Access to Directory

I am currently getting a locally hosted website up and running, but have encountered problems in accessing it from the host computer and other computers, as well. I have already created exceptions in ...
3
votes
2answers
38k views

MySQL server PID file could not be found

I can start mysql fine, /usr/local/mysql/support-files/mysql.server start Starting MySQL SUCCESS! But any mysql action after that I get the error: MySQL server PID file could not be found ...
0
votes
0answers
6 views

MySQL in WAMP for Commercial App [duplicate]

I have a java application that connects to a MySQL database. My question is, is MySQL in WAMP free to use in a commercial application? Do I have to pay for MySQL license?
2
votes
2answers
26 views

What are the benefits of connecting to MySQL using PHP-PDO's SSL attribute?

I primarily develop PHP applications using MySQL as my database. Generally, the server running the application is on the same box as the MySQL server, though not always. I was reading in the PHP docs ...
1
vote
1answer
70 views

Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock

I recently moved my mysql datadir from /var/lib/mysql to a new directory /home/mysql mounted on a new hard drive. For neatness sake I thought it'd be nice to place the tmpdir and socket on this new ...
1
vote
1answer
46 views

MySQL (MariaDB) crashing

Good morning - I have reviewed a previous post regarding changing the performance schema to "Off in the configuration settings. It looks as though our configuration is already set to this. So not sure ...
10
votes
9answers
18k views

How to capture the queries run on mysql server?

We're trying to do some server performance debugging and I would like to capture a snapshot of the queries being run on our mysql server over a period of a couple minutes. I'm familiar with mysql's ...
1
vote
4answers
136 views

Is it possibble to reboot a remote MySQL server on Ubuntu from a program or script on a Mac? [closed]

I have a client who has a web server hosted with Digital Ocean and they have a weird random MySQL database issue... 1-4 times a month there database server crashes and has to be manually rebooted. I ...
0
votes
0answers
11 views

MySQL server crashes weekly for over a year on Ubuntu with error log entries [duplicate]

My client has a basic LAMP web-server running on Ubuntu 14.x.x at Digital Ocean used to host a WordPress blog site. Very unfortunately for the past year there has been a random MySQL server crash 2-4 ...
1
vote
1answer
12k views

MySQL server quit without updating PID file

I need help on how to start the mysql server. The problem arise when the root directory was full. To be able to login to directadmin and start mysql, I added a soft link of the /var/lib/mysql/ to ...
0
votes
1answer
18 views

ubuntu - Postfix mail sent from server not logged in mail.log or phpmail.log

I am having server which hosts 70-80 websites and also using relay server for smtp using postfix using mysql database for domain and email boxes. I have also activated the phpmail.log for sendmail. ...
1
vote
0answers
79 views

Unable to login to MySQL on ownCloud using PHP - SQLSTATE[28000] [1045] Access Denied

I get a SQLSTATE[28000] [1045] Access Denied error every time I try to connect my ownCloud instance to my MySQL database as <user>@localhost. This is on a clean, newly installed copy of Ubuntu ...
0
votes
2answers
3k views

Run mysqld under a different user (linux)

I've been trying to start mysqld under a different user as well as with a different data path. I've done so by modifing the my.cnf file as follows: [mysqld] datadir=/bob/database ...
0
votes
0answers
35 views

Extremely weird proftpd behavior

I have configured proftpd + mysql and it is working Its working perfectly despite the overcomplicated queries. However when I enable DefaultRoot ~ It stops working and somehow reverts to some ...
0
votes
1answer
62 views

PHP not able to connect to MySQL

I just compiled PHP 7.0.4 on a Fedora 23 box, created a test script to connect to MySQL on localhost and all I get is: Error: Unable to connect to MySQL. Debugging errno: 2002 Debugging error: No ...
6
votes
3answers
8k views

Issue with maximum row size in MySQL

I have a problem with MySQL, I have a table with many text fields. When I try to store some data I obtain this error. Row size too large. The maximum row size for the used table type, not ...
0
votes
0answers
7 views

MariaDb hangs on insert from SELECT with subquery

I have the following query: INSERT INTO lists (list, entity_id) SELECT '13633' list, entity_id FROM ( SELECT must1_entity.id entity_id FROM entity must1_entity WHERE ...
3
votes
4answers
5k views

mysql my.cnf ignored

The Issue I'm trying to modify a my.cnf value on my production server but the changes aren't taking effect after a sudo service mysql restart, using an exact copy of the my.cnf (downloaded and ...
48
votes
8answers
51k views

What is the debian-sys-maint MySQL user (and more)?

I have been bitten several times by the 'debian-sys-maint' user that is installed by default on the mysql-server packages installed from the Ubuntu repositories. Generally what happens is I pull a ...
0
votes
1answer
72 views

Auto-start MariaDB using systemd after it has crashed

I am trying to set up MariaDB in a way that it automatically recovers -- basically restarts, from a crash. Based on this article -- scroll down to Auto-starting Services with systemd, I opened ...
55
votes
17answers
62k views

`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 ...
3
votes
2answers
4k views

How to set up multiple web and database servers?

My websites have been growing in terms of traffic and the load on the mysql has been increasing. I wanted a solution that would help deal with the increased load on mysql (all queries already ...
0
votes
1answer
1k views

Unable to connect to mysql on Windows Azure Virtual Machine

I created a virtual machine on Windows Azure. In that I installed MySQL. Every thing works fine on the server. I am not able to connect to MySQL remotely. Steps performed: Installed MySQL Created ...
0
votes
0answers
16 views

MySQL Cluster: Too Many Connections

We have our java application directly connected to the MySQL cluster (NDB engine) with 1 SQL Node. We also have another SQL node. We had a requirement to load balance our 2 SQL Nodes with the physical ...
0
votes
1answer
1k views

installing old MySQL client libraries (libmysqlclient.so.15, libpq.so.4)

I'm attempting to install Nagios plugins on a Zimbra 8.0.2 server running CentOS 6.4, but have run into the following error when I run yum install nagios-plugins-all Error: Package: ...
0
votes
0answers
14 views

Trouble getting automysqlbackup to keep connection to mysql server

I am trying to follow the instructions from the following page to set up backups for mysql. https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/ However, once I get to ...
0
votes
0answers
15 views

MariaDB replication- slave with high loadavg

We recently set a master-slave replication with MariaDB 10.1.12 on RedHat 6.7 fully patched. Master and slave are powerful Dell R730 with 2 RAID arrays- 1) 2 x 15k SAS drives for OS in RAID1 2) 4 x ...
1
vote
0answers
20 views

Recover MySQL MyISAM BAK files

I had some hard disk issue on my server and I noticed a MySQL table is missing lots of rows (5k instead of about 200M). In the MySQL directory I have a BAK file for that table : ...
0
votes
1answer
84 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 ...