MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

12
votes
8answers
3k views

is this a hack attempt?

Looking through my 404 logs I noticed the following two URLs, both of which occurred once: /library.php=../../../../../../../../../../../../../../../../../../../../../../../../proc/self/environ and ...
12
votes
3answers
24k 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 ...
12
votes
6answers
51k views

How to check what port mysql is running on

On my windows dev box mysql is running on port 3306 How can I check what port it is running on the unix server that I have to upload the app to.
12
votes
9answers
112k views

“Error 1067: The process terminated unexpectedly” when trying to install MySQL on Win7 x64 [closed]

I've run into a brick wall trying to install MySQL v5.5 on my machine. My PC is Windows 7 x64, Enterprise edition. MySQL installs fine, but when I run the "MySQL Instance Configuration Wizard", it ...
12
votes
2answers
33k views

What kind of server do I need to handle 10 million requests and mySQL queries a day? [closed]

I'm a newbie of server administration and I'm looking for a powerful hosting service to host my new website. This website is basically a back-end of an mobile online game, and it will: handle up to ...
12
votes
5answers
15k views

How to drop all tables in a MySQL database without dropping the database?

I need to drop all the tables in a database without knowing their names beforehand. The typical procedure is to drop and then recreate the database but this is not an option. What is the best way to ...
12
votes
17answers
4k views

MySQL monitoring tools

What tools do you use to monitor the health of your MySQL server instance? Are they for free or commercial?
12
votes
3answers
41k views

What does MySQL Error 2013 mean?

I'm running mysqldump on a mysql server in a cron (as backup) and I'm getting warning messages like mysqldump: Got error: 2013: Lost connection to MySQL server during query when doing refresh What ...
12
votes
3answers
1k views

The A to Z of setting up a Linux box for secure local hosting

I am in the process of reinstalling the OS on a machine that will be used to host a couple of applications for our business. The applications will be local only; access from external clients will be ...
11
votes
2answers
13k views

Command to create MySQL database with Character set UTF-8

I use create database dbname; to create database. but I want it to created with Character set UTF-8 Anyone know what is the command to use?
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, ...
11
votes
5answers
794 views

Is it bad to have a very full hard drive on a high traffic database server?

Running an Ubuntu server with MySQL for a high traffic production database server. Nothing else is running on the machine except the MySQL instance. We store daily database backups on the DB server, ...
11
votes
3answers
11k views

MySQL users changed their IP address. What's the best way to deal with this?

I have a number of users who are connecting to MySQL over a VPN, so we have grants along the lines of "grant select on foo.* to user@ipaddress1" and so on. This week, the IP used on the VPN changed ...
11
votes
6answers
41k views

How to completely remove MySQL from Windows?

(I realize there are similarly-titled questions, but this one is really 'how do I reset the password', and this one doesn't specify an OS and has only gotten Linux-oriented answers.) On Windows XP, I ...
11
votes
3answers
21k views

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, ...
11
votes
5answers
14k views

Using mysqldump in cron job without root password

If I login with the root password on my box I can simply type mysqldump --all-databases and I will get th expected "Dump". I setup a job in cron.daily to run and dump this to a backup drive. The ...
11
votes
3answers
15k views

Set group_concat_max_len permanently (MySQL config)

I have MySQL installed on an Ubuntu machine. I added this line in /etc/mysql/my.cnf group_concat_max_len=15360 But there is no effect. Every time I restart mysql, the value is set to 1,024. I have ...
11
votes
6answers
18k views

Where does MySQL store its database files on OS X?

As I would like to move those files from one server to another server, while the database is offline.
11
votes
3answers
2k views

MySQL replication across geographically separate servers

My organisation has been looking into how to spread our servers around geographically while keeping backups very up to date, and ideally spreading the load. The initial thing I have in mind is Rails ...
11
votes
2answers
8k views

How do I setup monitoring of MySQL with Fail2ban?

Searching the internet with search engines on MySQL and fail2ban yields lots of results on putting your fail2ban logs into MySQL, however I'm wanting to monitor failed MySQL attempts to log in and ban ...
11
votes
2answers
10k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
10
votes
9answers
7k views

How to store 3 million records in key value format?

We have to store basic information about 3 million products. Currently the info is one 180 mb CSV which gets updated quarterly. There will be about 30,000 queries per day, but the queries are just a ...
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 ...
10
votes
5answers
2k views

How can I backup multi-gigabyte databases in MySQL? Bonus points for speedier restores

I have a 4GB database in MySQL. How can I back it up? Furthermore, is there a way that I can speed up the restoration process in the event that I need to recover? I currently use a cron job every ...
10
votes
3answers
34k 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 ...
10
votes
4answers
3k views

Fix Control-C in mysql command line programme?

In the mysql command line, pressing Control-C will cancel the programme, and bring you back to bash. In psql, the one for postgres, it will kill the current query and will not stop the psql programme. ...
10
votes
3answers
11k views

How to escape ! in password?

How might one escape the exclamation point in a password: $ mysql -umyuser -pone_@&!two -bash: !two: event not found Trying the obvious backslash did not help: $ mysql -umyuser -pone_@&\!...
10
votes
3answers
14k views

Why are outdated packages installed by yum on CentOS? (specifically PHP 5.1) How to fix?

I'm working on a fresh CentOS server and am extremely annoyed to find out that yum does not work as smoothly and brilliantly as "apt-get install" does on Ubuntu. Installing a LAMP stack, I ran the ...
10
votes
1answer
17k views

How to automatically start mysql after server restart (CentOS + other distros)?

How would I configure my CentOS Linux server to automatically start mysql when the server is started following a shutdown? I'm aware of the init.d path... /etc/rc.d/init.d ...and I can see mysqld ...
10
votes
2answers
3k views

What should I know before going live with an InnoDB database?

What things should a server- or DB-admin know and do before making a InnoDB database available. I'm thinking about things like setting correct values for innodb_buffer_pool_size and ...
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 ...
10
votes
3answers
14k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
10
votes
3answers
3k views

Mysql Encryption and Key managment

I am developing a local intranet system in PHP/MySQL to manage our client data. It seems that the best practice would be to encrypt the sensitive data on the MYSQL server as it is being entered. I ...
10
votes
3answers
20k views

Changing host permissions for MySQL users

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

Has anyone migrated production machines from MySQL to MariaDB?

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be trivial,...
10
votes
3answers
2k views

Optimizing Apache and MySQL on Linux Xen VPS

I have a Xen virtual private server (VPS) running Ubuntu 8.10, with 128M RAM. I've found several "how to optimize Apache and MySQL for low-memory VPS" pages via Google, but they provide contradictory ...
10
votes
2answers
6k views

MySQL doesn't logs error to new file after rotating?

Problem solved but I'm writing down for the future reference. /root/.my.cnf [mysqladmin] user = root password = pa$$w0rd /etc/logrotate.d/mysql /var/log/mysql-slow.log /var/log/...
10
votes
2answers
7k views

Why are all MySQL InnoDB tables fragmented?

For some reason, all InnoDB tables in my MySQL server are being listed as fragmented when I run mysqltuner. I only installed the server a few hours ago (on OSX Lion), and it has a bunch of fresh data ...
10
votes
1answer
650 views

iptables not allowing mysql connections to aliased ips?

I have a fairly simple iptables firewall on a server that provides MySQL services, but iptables seems to be giving me very inconsistent results. The default policy on the script is as follows: ...
10
votes
2answers
1k views

Is there a MySQL performance benchmark to measure the impact of utf8_unicode_ci versus utf8_general_ci?

I read here and there that using the utf8_unicode_ci collation ensures a better treatment of unicode text (for example, it knowns how to expand characters such as 'œ' into 'oe' for searching and ...
10
votes
2answers
706 views

MediaWiki slow save of edited pages

I have MediaWiki 1.16.2 on a the following LAMP platform, which performs quite good for other apps on a 16 GB RAM dual processor machine: CentOS 5.7 (64-bit) Apache 2.2.3 MySQL 5.0.77 PHP 5.1.6 It ...
9
votes
8answers
945 views

What is a relational database? [closed]

I'm mostly a system administrator and I don't directly work with databases other than installing them, setting up accounts, granting privileges, and so on. I realized that if The Boss walked up to me ...
9
votes
6answers
14k views

Use LDAP for MySQL authentication?

We run a couple dozen different MySQL servers for our users. These use the free/Open Source version of MySQL, not the commercial version. Managing the Account Passwords on these servers is painful. ...
9
votes
4answers
11k views

MySQL 5.1 or 5.5?

Are there significant differences between versions 5.1 and 5.5? The server in question is used to host a medium-sized vBulletin forum. The main benefit of 5.1 is it's available through apt-get.
9
votes
3answers
17k views

How to automatically kill slow MySQL queries after N seconds?

I am looking for a well tested bash script (or alternative solution) to do so, in order to avoid max_connection to be exhausted. I know that it is fighting the symptoms, but really need such script as ...
9
votes
9answers
31k views

How can I reset the password for MySQL? [duplicate]

I have an old MySQL installation for which I do not have the password. How can I reset the password? My first idea was to completely remove it and reinstall with a new password. I am using Windows ...
9
votes
5answers
13k views

Can a MySQL slave be a master at the same time?

I am in the process of migrating 2 DB servers (Master & Slave) to two new DB Servers (Master and Slave) DB1 - Master (production) DB2 - Slave (production) DB3 - New Master DB4 - New Slave ...
9
votes
2answers
322 views

My server setup for a heavily used API

I will soon be buying a bunch of servers for an application that I am about to launch but I have concerns about my setup. I appreciate any feedback I get. I have an application which will make use of ...
9
votes
3answers
668 views

Anyone used MySQL Forks in Production

Now that MySQL is owned by Oracle many are starting to consider using some of the popular forks such as MariaDB and Drizzle. Has anyone used these in production for any extended periods of time? If ...
9
votes
2answers
13k views

MySQL InnoDB database 'hangs' on selects

I'm trying to fix MySQL configuration on our server. Our app's specifics is that a lot of data is stored in single table (currently over 300 millions of rows). This table is used often for inserts (...