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.
8,731
questions
6
votes
6
answers
33k
views
How might one mass kill connections to MySQL?
I've opened too many connections to MySQL and now I can't access it. It says "Too many connections". How can I close all of these connections?
I also don't know how to restart it, which may resolve ...
1
vote
1
answer
1k
views
Problem with mysql (mariadb) crash
An hour ago I noticed that the mysql (mariadb 5.2.5) server is not running on my debian VPS. So I immediately ran "/etc/init.d/mysql restart" and it started just fine. Here's what the daemon log says ...
0
votes
1
answer
2k
views
Mysql: Innodb error when migrating mysql from linux to windows
I have migrated my data directory for an InnoDB mysql server from a linux machine to a windows machine. I started the server up, selected the database, and tried to query a table. Got the error "Table ...
2
votes
1
answer
1k
views
mysql server hanging on 'show processlist;'
I've got a problem where my mysql server gets into a state where basic operations hang forever.
$ mysql -ubuildbot -p -hdbserver
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL ...
17
votes
2
answers
7k
views
Connecting to MySQL securely - MySQL's SSL vs Stunnel vs SSH Tunneling
We have a PHP application which connects to a MySQL server, and we wish to secure connections between the web & application servers and the database.
At peak times, the web servers make many ...
-1
votes
1
answer
177
views
DBmail not receiving mail
I setup DBmail (MySQL) with Postfix and stunnel, but I still can't receive mail. I can login to the server though. But when I send a mail to a user that I created with dbmail-user:
dbmail-users -a ...
3
votes
3
answers
4k
views
Secure MySQL replication; SSL or SSH tunneling?
I have a Master-Master MySQL replication setup between two servers. I'm about to move one to another location, so replication will be over the Internet and will - of course - need to be secured.
...
0
votes
1
answer
2k
views
MySQL hosting: What are the recommended specs and w
I have two specific cases of MySQL hosting.
1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to ...
0
votes
3
answers
357
views
server upgrade from mysql What do you think
Curious to get feedback on a server selection. the system will run mysql server, with roughly 80 machines accessing the server at all times (except night)
> PowerEdge R610 Chassis for Up to Six 2....
1
vote
1
answer
72
views
On first Windows install mysql.db is empty even though I can see the Test database through other means
I've installed MySQL for the first time. I used the MySQL 5.5.11 for Windows and used the MySql Server Instance Configuration Wizard, and chose a root password.
When I tested the system compared to 2....
0
votes
1
answer
4k
views
SQL Error (1064) when importing data from SQL file
I have a MySQL database, which was originally set up with the default latin1 character set and latin1_swedish_ci collation. I was using the database like this for sometime, until I noticed strange ...
1
vote
2
answers
2k
views
where is mysql_config located on ubuntu?
I am trying to install mysqldb for python as per this tutorial and running into the mysql_config problem.
http://www.geeksww.com/tutorials/web_development/python/installation/...
0
votes
2
answers
148
views
Where do I find a MySQL self-installer for OSX?
I don't have the resources or know-how to install MySQL from source, and the downloads page on Mysql.com only provides versions that require lots of manual linking.
Isn't there anywhere that ...
0
votes
2
answers
300
views
How to upgrade apache, php, mysql
I'm looking to update our web server, and my experience with updating is slim. I have done clean installs of apache, php, and mysql, but this will be my first time upgrading. Hoping someone can give ...
0
votes
1
answer
127
views
mac os x server running mysql servererror - services wont start
Mysql server running on Mac OS X
the my.cnf file had max_connections = 10000000
client got the error 'max connections reached'
restarted server, now it won't start the mysql services
bellow is an ...
32
votes
2
answers
53k
views
Is MySQL port 3306 encrypted, and if no, how can I encrypt it?
I am working through a security audit for a system at my work and one of the requirements is to encrypt all traffic through public/unprotected networks. Since we are accessing the MySQL database (over ...
2
votes
1
answer
52
views
Debain FTP server software, which one supports my setup? [closed]
Im looking for some FTP server software for Debain 6.0 Squeeze that can support the following:
Username/password from MySQL.
Separates each user login into its own directory.
In the users directory, ...
3
votes
1
answer
369
views
MySQL-Proxy not loadbalancing
This is my current test setup:
SQL0: 192.168.22.64 (master+slave)
SQL1: 192.168.22.65 (master+slave)
loadbalancer0: 192.168.22.66
loadbalancer1: 192.168.22.67
Virtual IP: 192.168.22.80
The ...
1
vote
1
answer
972
views
Will innodb benefit from memcached?
from - http://www.readwriteweb.com/hack/2011/04/you-got-nosql-in-mysql-memcach.php
(correct me if does not make sense)
potential benefits
saving complex query calculation into distributed ...
0
votes
2
answers
441
views
Sphinx indexer slows down the database: How to give it low priority?
All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still very slow if you make a request right after a new step ...
1
vote
2
answers
4k
views
Cannot connect to MySQL server after too many connections?
Today my DB server reached the maximum number of connections and my web applications (in another server) show "too many connections" error message. After that I restarted MySQL server but a new ...
1
vote
1
answer
161
views
What is the best option for a MySQL server host?
I am a noob in the world of servers. I understand SQL databases but I don't know how to setup a server. I would like to setup a MySQL server that I can talk to (read/write) from an app that I wrote ...
1
vote
2
answers
3k
views
Upgrade Mysql 5.0.26 to the latest version?
Ok, I have tried to browse the web but I am not sure how to do this. My server is a production server and I want a smooth upgrade, is this possible? Could I just download the latest version of mysql ...
0
votes
2
answers
192
views
MySQL 5.x: equivalent of \s but for another connection?
When you use the mysql-client and run \s it shows you the status of the current user. I'm testing out SSL connection(s) and I want to be able to find out the SSL status, etc. of another connection id....
1
vote
2
answers
164
views
MySQL Replication Server Error
My replication server showing the following error,Please go through the query and tell me your comments.The insert query is working in live DB server Properly , but showing error in replication DB ...
1
vote
2
answers
369
views
Mysql crashes by some strange queries
I have some strange log entries in my debug where I see that the mysql crashes:
Apr 13 08:51:16 cronjob1 mysqld[22953]: Attempting backtrace. You can use the following information to find out
Apr 13 ...
0
votes
2
answers
1k
views
Confusing MySQL error/warning/info message
I am having trouble administering my MySQL. I tried to stop it like this:
/etc/init.d/mysql stop
and I got this message:
Rather than invoking init scripts through /etc/init.d, use the service(8)
...
4
votes
6
answers
86k
views
Unable to connect to MySQL through port 3306
I read the answers about 3306 from a question posted in 2009. I have the same problem, but the answers I read didn't help. Port 3306 is open, even if I stop the windows-firewall, MySQL still can't ...
2
votes
2
answers
1k
views
mysql server won't start, has worked for months.
What I was did before I restarted server: ran OpenEMM.sh start for installing OpenEMM.
This shouldn't have done anything to this mysql install.... I've tried to fix permissions, verified that plugin....
0
votes
2
answers
3k
views
Access denied for user 'xxx'@'xxx.xxx.xxx.xxx'
I know that there are similar questions, but I didn't find exactly what I'm looking for. Here's what happens and it's kinda strange:
[root@xxx xxx]# mysql -u profuser -ppwd -h 192.168.1.99
ERROR 1045 ...
0
votes
2
answers
3k
views
Problem with WireShark (MySQL sniffing)
How can I snif MySQL data using WireShark? Also I used «mysqlsniffer» and have no results. There are no any packets from MySQL. I've filtered by «MySQL.isPresent» in WireShark but nothing happened.
...
2
votes
1
answer
1k
views
How to change UNIX user password using passwd if user is stored in a MySQL database?
I'm trying to setup libnss-mysql and libpam-mysql. So far everything has been working. I can use id to get information about the users stored in my databas. getent passwd is working, as well. However, ...
2
votes
5
answers
4k
views
CentOS and MySQL
So I have this VPS on CentOS. A few months ago, I installed apache2, mysql and some other stuff, to host a wordpress blog. Now, for some reason, the mysql service has shutdown, and I'm unable to ...
0
votes
1
answer
126
views
Problem uploading my vexim database
Am trying to upload my vexim database but this is the error i get. Anyone with an idea how to solve this? I have tried it with two versions of vexim that is vexim2.2.1.and vexim 2 but i got the same ...
0
votes
8
answers
155k
views
Can't access phpMyAdmin because of host, username and password
everyone. When I try to access phpMyAdmin on Uniform Server I get the following error messages:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
phpMyAdmin tried to connect ...
4
votes
2
answers
1k
views
How to scale my.cnf settings and variables for move from 16GB server to 128GB
This is a general question about optimal setup for a MySQL environment really, but our current MySQL servers are setup on machines with 16GB RAM, we've recently upgraded to newer servers (more ...
0
votes
1
answer
680
views
Gerrit uses wrong collation
I'm trying to authenticate Gerrit users using ldap against Active Directory.
I get the following error.
ERROR com.google.gerrit.server.cache.PopulatingCache : Cannot lookup CN%3DORG+%C3%96resund+...
0
votes
1
answer
188
views
safe steps to upgrade mysql from 5.0.45 to 5.1.49 on fedora 8
I have a server running on Fedora 8 64-bit and am looking for a safe procedure to upgrade MySQL from version 5.045 to 5.1.49.
3
votes
2
answers
574
views
When - if at all - should I switch from MySQL to MariaDB?
Now that MySQL is owned by Oracle, the future of the RDBMS seems uncertain. The fork by the main developer of MySQL, Monty Widenius, called MariaDB, is a drop-in replacement for MySQL. Version numbers ...
2
votes
3
answers
1k
views
VPS set up for MySQL
Our VPS is set up in such a way that all databases are accessible from any domain via localhost and the username/password/dbname.
Is this the usual set up, or should there be some way of 'jailing' ...
2
votes
5
answers
6k
views
Attempted to change database drive resulted in "Can't connect to local MySQL server through socket"
I attempted to move my database to a different mount on my Ubuntu installation on an amazon EC2 instance, because it was filling up the root directory. I think I've borked something up. When I run:
$ ...
1
vote
2
answers
961
views
Setup MySQL per account limits similar to shared hosting
Similar questions have been asked before, such as this one, but none of the answers I've seen so far really tell me what I'm after.
I have a need to set up a Linux box for internal development and ...
0
votes
1
answer
906
views
Installing python-mysql on windows with AppServ
I am trying to install the python module "mysql" on Windows 7 with apache installed with AppServ (installation includes Apache, MySQL and PHP).
When I try to run the setup.py script of "python-mysql" ...
1
vote
2
answers
1k
views
My server is sending spam
I have a dedicated server with CentOS+MySQL installed from godaddy.com. Recently I had some very weird problems: I installed a PHP application which has a thread that queries a MySQL database for ...
1
vote
0
answers
2k
views
How can I set up mysql logs so that syntax errors are logged?
I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless.
How can I log only mysql queries that ...
1
vote
2
answers
3k
views
Can I backup a mysql index? On an innodb table?
I have several tables that are 10's of millions of rows, and have multiple indexes. When dumping and reloading the data it takes quite a while to reinsert because of the indexes, or to insert without ...
0
votes
4
answers
657
views
Advantages of MySQL Server Enterprise
We build for a customer a social network site, where we will have on beginning 1 Master and 2 Slave MySQL Server.
I'm not sure if we need to go with the Enterprise or use the GA Version. The only ...
0
votes
1
answer
538
views
Apache says MySQL daemon already running; if I stop the other daemon, Apache can't start its own
What should happen:
./lampp start mysql -u root -p
--All is right and well with the world!--
What actually happens, and in this order:
./lampp start
mysql -u root -p
[Can't connect to local ...
0
votes
1
answer
2k
views
Mysql and Windows Server 2008 R2 SP1
I today install SP1 on my Windows Server 2008 R2, but after the mandatory reboot are the MySQL server unable to start, where i get the following error.
C:\Users\Cronjob>"C:\Program Files\MySQL\...
1
vote
2
answers
4k
views
Unknown command error while restoring database from MySQL dump
I am using MySQL 5.1.36. While importing form a MySQL dump
I am getting the following error. The 'max_allowed_packet' size is set to 100M in the my.cnf.
ERROR at line 1647: Unknown command '\''.
Can ...