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.

Filter by
Sorted by
Tagged with
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 ...
Lucas's user avatar
  • 161
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 ...
stormbreaker's user avatar
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 ...
coderego's user avatar
  • 175
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 ...
user79205's user avatar
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 ...
dastra's user avatar
  • 305
-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 ...
Kevin's user avatar
  • 61
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. ...
Andrew Ensley's user avatar
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 ...
ramdaz's user avatar
  • 695
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....
Jeff's user avatar
  • 1,089
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....
Mark Hurd's user avatar
  • 134
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 ...
unpossible's user avatar
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/...
ian's user avatar
  • 127
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 ...
nessur's user avatar
  • 113
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 ...
Brett's user avatar
  • 3
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 ...
Jeff's user avatar
  • 1,089
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 ...
Stephen RC's user avatar
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, ...
Petah's user avatar
  • 650
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 ...
Tuinslak's user avatar
  • 1,475
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 ...
ajreal's user avatar
  • 183
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 ...
HappyDeveloper's user avatar
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 ...
usef_ksa's user avatar
  • 845
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 ...
David's user avatar
  • 197
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 ...
Joakim Krassman's user avatar
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....
gravyface's user avatar
  • 14k
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 ...
Jayakrishnan T's user avatar
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 ...
Nik's user avatar
  • 11
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) ...
Genadinik's user avatar
  • 1,143
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 ...
Ron's user avatar
  • 41
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....
mprototype's user avatar
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 ...
Kiril Kirov's user avatar
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. ...
Clark's user avatar
  • 337
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, ...
t6d's user avatar
  • 537
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 ...
Afrosimon's user avatar
  • 135
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 ...
Sspec's user avatar
  • 1
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 ...
Engprof's user avatar
  • 17
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 ...
kwiksand's user avatar
  • 463
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+...
Robert's user avatar
  • 109
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.
Ibrahim AbuRajab's user avatar
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 ...
polemon's user avatar
  • 595
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' ...
Owen's user avatar
  • 356
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: $ ...
Kit Sunde's user avatar
  • 946
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 ...
John Gardeniers's user avatar
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" ...
Joel's user avatar
  • 127
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 ...
user avatar
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 ...
Kzqai's user avatar
  • 1,288
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 ...
Zak's user avatar
  • 1,042
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 ...
Nenad's user avatar
  • 375
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 ...
Thomas Thorogood's user avatar
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\...
Androme's user avatar
  • 411
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 ...
Supratik's user avatar
  • 2,174

1
129 130
131
132 133
175