Questions tagged [mysql]
MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
473
questions
32
votes
5
answers
15k
views
Why not use a WAMP stack?
This is a canonical question about the use of a *AMPP's 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 ...
14
votes
4
answers
14k
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 ...
16
votes
2
answers
11k
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 ...
1
vote
1
answer
2k
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 ...
38
votes
6
answers
29k
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 ...
17
votes
3
answers
9k
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 ...
313
votes
8
answers
798k
views
How to bind MySQL server 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.
99
votes
11
answers
153k
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 ...
28
votes
11
answers
105k
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, ...
9
votes
2
answers
16k
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 ...
8
votes
2
answers
33k
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....
6
votes
1
answer
7k
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
2
answers
4k
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 ...
-2
votes
4
answers
10k
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 ...
50
votes
4
answers
192k
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 ...
23
votes
5
answers
20k
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
5
answers
5k
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 ...
12
votes
3
answers
48k
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 ...
10
votes
3
answers
6k
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 ...
4
votes
2
answers
2k
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 ...
2
votes
2
answers
2k
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
1
answer
5k
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?
78
votes
9
answers
120k
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 ...
49
votes
7
answers
56k
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 ...
30
votes
1
answer
97k
views
MySQL [Warning] IP address could not be resolved
I'm running MySQL5.6.3 on a CentOS 6.1 virtual machine running on Windows XP in VirtualBox.
The network card is configured in bridge mode, so my physical & virtual machines share the same ...
19
votes
9
answers
6k
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 ...
18
votes
6
answers
57k
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 ...
15
votes
3
answers
41k
views
MySQL access denied error when connecting via SSH tunnel
For months I've been connecting to the MySQL instance running on our local test server through an SSH tunnel without any issues. All of sudden though, with no changes I can think of, the server has ...
15
votes
6
answers
172k
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 ...
14
votes
1
answer
32k
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?
13
votes
7
answers
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 ...
12
votes
4
answers
31k
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
10
votes
1
answer
123k
views
Mysql showing 100% CPU usage [closed]
I'm experiencing some problems with my MYSQL server installed with Cpanel.
My server is showing 100% usage of mysql even if I don't have too much traffic on web.
I am running CentOS 6.5x64 with 80GB ...
7
votes
5
answers
9k
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 ...
7
votes
2
answers
11k
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 ...
7
votes
6
answers
7k
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?
6
votes
2
answers
8k
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
2
answers
6k
views
Unable to start Mysql with SELinux
I am attempting to start MySQL with SELinux on CentOS 6 however I am getting the following error.
131212 09:08:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131212 09:08:58 ...
5
votes
4
answers
502
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?
5
votes
5
answers
9k
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 then ...
4
votes
2
answers
55k
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
8
answers
10k
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 ...
1
vote
2
answers
13k
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' (...
1
vote
2
answers
5k
views
Can the startup order for windows services be configured? If so, where?
Windows Server 2003
MySQL 5.x
Hi Guys,
I have a service that requires mysql to be running when starting up. I'd like ensure that mysql itself starts well before other windows services during ...
0
votes
1
answer
718
views
I changed mysql root password and I cant access It. password contained some chars
using this command I changed root password
mysqladmin -u root password fg$pkh@567fghu
And now I cant access mysql. Is this because mysql parse the chars other than what I expect?
Also I completely ...
110
votes
1
answer
158k
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
...
72
votes
3
answers
197k
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 ...
71
votes
7
answers
142k
views
How to force MySQL to connect by TCP instead of a Unix socket?
I would like to analyze mysql traffic. Right now, all mysql requests are sent to the MySQL unix socket:
unix 2 [ ACC ] STREAM LISTENING 3734388 15304/mysqld /var/run/mysqld/...
66
votes
12
answers
227k
views
MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11
I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
46
votes
7
answers
57k
views
Forward local port or socket file to remote socket file
Quick question - I run two linux boxes, one my own desktop and the other my VPS. For security reasons on the VPS end I opted for socket connections to MySQL (/var/run/mysqld/mysql.sock). I know I can ...