MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

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 ...
14
votes
4answers
5k views

How to reset or recover admin account password for MySQL?

I have a MySQL database that I "inherited" and I was not given the admin credentials. I do however have access to the box that it runs on. Is there a way to either recover the admin credentials or ...
14
votes
2answers
8k views

Installing a third party application package on CentOS 6.4 fails due to missing dependencies libcrypto.so.10 and libssl.so.10

This is a Canonical Question about OpenSSL binary compatibility issues between Red Hat Enterprise Linux (and its derivatives) 6.4 and 6.5. This issue applies to a wide variety of third party ...
0
votes
1answer
1k views

Ubuntu 12.04 Server - MySQL keeps crashing - Possible InnoDB problems

I have been searching for a solution but nothing seems to work. I have a single Drupal 6 website up on this server. Server:Ubuntu 12.04 Apache/2.2.22 (Ubuntu) 5.3.10-1ubuntu3.8 MySQL 5.5.32 Drupal ...
21
votes
7answers
14k views

MySQL InnoDB - innodb_file_per_table cons?

By default MySQL InnoDB stores all tables of all DBs in one global file. You can change this by setting innodb_file_per_table in the config, which then creates one data file for each table. I am ...
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 ...
4
votes
1answer
3k views

what is gen_clust_index used for in mysql?

It seems I have a deadlock in mysql (running innodb) that's due in part to a lock on gen_clust_index, however, this isn't a table that I've created. So... what's the short and sweet description of ...
-1
votes
2answers
3k views

Poor SQL performance on HP ProLiant ML310e Gen8 v2 with raid10

I recently bought HP ProLiant ML310e Gen8 v2 server with 8G's RAM and 4 HP 1TB 6G 7.2k rpm SATA (3.5in) Non-Hot Plug MDL HDD disks. It was surprise to me that HP didn't provide debian drivers for ...
20
votes
5answers
15k views

Scripted install of MySQL on Ubuntu

I need to write a script that will build my server from a fresh Ubuntu server install. Among things like Apache and PHP it needs to install MySQL. The only problem here is that when I install MySQL ...
14
votes
5answers
4k views

What is the best way to monitor a production server?

We are running two production servers with Apache 2 and MySQL. I am looking for a reliable way of monitoring our load, stability and uptime. I have come across monit, but are there better ...
10
votes
3answers
3k views

Secure LAMP server for production use

What is the procedure for securing a Linux, Apache, MySQL, PHP Server (or even Perl) for production use? Other than setting the MySQL password and the root password for Linux what other (maybe not so ...
8
votes
3answers
13k views

How to copy user privileges with MySQL?

I have a MySQL installation with many databases and users that I need to migrate to a new MySQL installation. I can use phpMyAdmin to export then import the databases/tables, but I don't know of ...
4
votes
2answers
10k views

MySQL: Allow both remote AND local connections

In my Ubuntu's /etc/mysql/my.conf, I have: bind-address = 192.168.2.20 # My external IP It works fine from remote, but when I want to connect locally, the app that uses on MySQL says: java.net....
2
votes
2answers
243 views

MySQL allows entry without Password [duplicate]

I have configured my MySQL Database to require passwords on all users, even root from the machine itself. Now I discovered that there are empty Users in my Database Reproduce: mysql -u root -p and ...
1
vote
1answer
2k views

How do I set my.cnf in Mysql so that there are no limits to connections?

Unlimited connections, how do I edit that setting?
-1
votes
4answers
4k views

Dump all databases with SSH access

I would like to know how to dump all databases into a folder. I'm using a Linux/Debian Afer connecting on the server with root access I make $ mysql -u admin -p To connect on mysql. Then which ...
4
votes
2answers
1k views

MySQL 5.5.16 allows anonymous connections

Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access ...
64
votes
10answers
85k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
18
votes
9answers
5k views

Architecture for highly available MySQL with automatic failover in physically diverse locations

I have been researching high availability (HA) solutions for MySQL between data centers. For servers located in the same physical environment, I have preferred dual master with heartbeat (floating ...
164
votes
5answers
258k views

MySQL: Bind to more than one IP address?

Is there a secret way to bind MySQL to more than one IP address? As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.
43
votes
7answers
38k views

What is the best Linux filesystem for MySQL (InnoDB)?

I tried to look for benchmark on the performances of various filesystems with MySQL InnoDB but couldn't find any. My database workload is the typical web-based OLTP, about 90% read, 10% write. Random ...
13
votes
7answers
2k views

Backup MySQL Server

What's the best way to back up a MySQL server? I would like a method that doesn't require bringing down the server. Is something like InnoDB hot backup necessary, or can I just use the backup tools ...
7
votes
6answers
40k views

Mysql - Access denied for user 'root'@'x.x.x.x' [duplicate]

I am trying to connect to a remote mysql database from my local box. Initially I was not even able to hit the mysql db. But after commenting the binding_address in the my.cnf file and restarting the ...
6
votes
2answers
5k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
6
votes
2answers
7k views

How do MyISAM and InnoDB Utilize HD Space?

My MySQL server is running out of HD space fast. Most of my larger tables use the InnoDB engine (for no mission-critical reason). In an effort to avoid the dreaded 'drop database to recover innodb ...
17
votes
9answers
46k views

MySQL cannot connect via “localhost”, only 127.0.0.1

this is somewhat of a mystery to me. The only way I can connect to MySQL is if I call it via "127.0.0.1" ... for example, my PHP connect script will NOT work with localhost I'm running Mac OS X Lion, ...
8
votes
2answers
8k views

mysqldump prompting for password in shellscript

I wrote a simple shell script to dump a specific mysql database. problem is it is prompting me for a password even though I provide on. The mysql db is version 5.0.27 if that matters. Here is the ...
7
votes
6answers
5k views

Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?

I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?
4
votes
5answers
5k views

How can I back up and replicate a large MySQL database?

How can I backup a large database in mysql? And what is the best way to replicate the database? what i'm looking for is backing up large database with large amount of data in a small time limit ...
4
votes
2answers
11k views

How to log on MySQL on CentOS 6.3 using root account from the domain and not localhost?

I don't know if I'll make the issue clear, but I've installed MySQL on CentOS 6.3 using root account on a specific domain (f.ex. root@mydomain), but when I try to log on to it I'm being asked for ...
3
votes
8answers
6k views

MySQL is running VERY slow on CentOS 6x (not 5x)

I have two servers: a VPS and a laptop. I recently re-built both of them, and MySQL is running about 20 times slower on the laptop. Both servers used to run CentOS 5.8 and I think MySQL 5.1, and the ...
5
votes
4answers
18k views

Linux / mysql: is it safe to copy mysql db files with cp command from one db to another?

Most guides recommend mysqldump and simple SQL for copying one table to anoter db. How about linux shell cp? Can I just simply do cp /db1/mytable.frm /db2/mytable.frm
1
vote
2answers
11k views

How should I diagnose ERROR 1045 during MySQL installation?

I recently setup a MySQL server and encounted the following error when I ran the mysql console (and incidentally the administrator GUI tool): ERROR 1045: Access denied for user: 'root@localhost' (...
6
votes
5answers
4k views

MySQL stopped working - full disk

Maybe it is because I am lacking in free disk space, take a look: Filesystem Size Used Avail Use% Mounted on /dev/sda2 1.9G 208M 1.6G 12% / none 998M 192K ...
6
votes
1answer
10k views

How to restore mysql database from the physical files?

I just reinstalled my system, I didn't do dump backup but I still have the physical folder of my previous mysql installations. Is possible to use it to restore and update my current configuration?
5
votes
4answers
345 views

reseting mysql root password [duplicate]

Is there a mysql command to reset the root password? I am trying mysql -p -u root but I've forgotten the password. Is there any way to reset the password?
51
votes
8answers
53k 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 ...
17
votes
6answers
14k views

Optimize apache/php/mysql running on VPS for heavy load

Question about optimizing an apache/mysql server on a VPS with 512m of RAM. Under normal load everything runs fast, no connection lag. However when we get our heavy traffic days (50k+ visits) the ...
70
votes
1answer
86k views

InnoDB: Error: log file ./ib_logfile0 is of different size

I just added the following lines in /etc/mysql/my.cnf after I converted one database to use InnoDB engine. innodb_buffer_pool_size = 2560M innodb_log_file_size = 256M innodb_log_buffer_size = 8M ...
8
votes
9answers
3k views

How do you usually back up your database?

I am using mysql How often do you back up your database? How do you normally backup your database? Export all data into sql or cvs format and keep it in a folder??
8
votes
5answers
30k views

How to improve MySQL INSERT and UPDATE performance?

This question can probably be asked on StackOverflow as well, but I'll try here first... Performance of INSERT and UPDATE statements in our database seems to be degrading and causing poor performance ...
30
votes
8answers
53k 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 ...
28
votes
4answers
6k views

Why Swap is used when plenty of free memory is left?

I have pretty good web (dedicated) server with good memory resource System information Server load 2.19 (8 CPUs) Memory Used 29.53% (4,804,144 of 16,267,652) Swap Used 10.52% (220,...
11
votes
4answers
5k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
7
votes
6answers
21k views

IO Wait causing so much slowdown (EXT4 JDB2 at 99% IO ) During Mysql Commit

I am writing an indexer, using python, which indexes documents and insert them into Database, Before it was single process but now i made it to multiprocessing with 4 parallel processes running.After ...
20
votes
11answers
54k views

Can't start/stop mysql service

Taking over a Debian Etch web server with MySQL running. I usually start, stop and restart msyql using: /etc/init.d/mysql restart For some reason on this set up I get the following: :~# /...
20
votes
3answers
21k views

Out of resources for mysqldump

I'm trying to do a mysqldump on a Windows server and I get the following error message : mysqldump: Got error: 23: Out of resources when opening file '.\db\sometable.MYD' (Errcode: 24) when using ...
5
votes
4answers
5k views

Create a MySQL slave from another slave, but point it at the master

Problem I have MySQL replication setup between 2 servers, master (A) and slave (B). I need to add a new slave to the mix (C). I want this slave to get it's updates directly from the master, I do not ...
23
votes
5answers
61k 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 ...
6
votes
4answers
5k views

Percona-server time out on /etc/init.d/mysql start

Every time I start mysql, using /etc/init.d/mysql start or service mysql start, it always times out. * Starting MySQL (Percona Server) database server mysqld [fail] However, I ...