MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
1answer
43 views

Puppet - mysql module not pulling “my.cnf” from fileserver

Trying to deploy mySQL puppet. Using "Puppetlabs-MySQL" module. My puppetmaster'd pp has node 'jira.oracle' { class {'mysql::server':} } class mysql::server { package { "mysql-server": ensure ...
2
votes
2answers
3k views

403 Forbidden when trying to access a folder in document root of nginx

When I access index.php, it works fine. But on localhost/pset7, it gives a 403. Here is the permission log, -rw-r--r--. 1 root root 51 Jul 31 14:21 index.html -rw-r--r--. 1 root ...
4
votes
1answer
933 views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
0
votes
0answers
68 views
+50

Unable to query or connect, depending on bind-address

I have a simple script that is failing differently depending on the bind-address configuration. If I set bind-address to the IP address of the server and run the script the query times out. If its ...
8
votes
6answers
15k views

What should mysqld.sock contain, why don't I have it?

Does anyone know why my /var/run/mysqld/mysqld.sock socket file would not be on my computer when I install (or reinstall) MySQL 5.1? Right now, when I try to start up a server with mysqld, I get ...
0
votes
1answer
35 views

MySQL, NFS and symbolic links

I have been migrating an older server running apache2 + mysql under ubuntu to a new server running debian (wheezy). The migration works fine while the databases are storted localy (in our case ...
0
votes
1answer
1k views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
0
votes
1answer
14 views

PHP installation issue on a Windows Server hosted in the Azure cloud

I am trying to setup PHP and MySQL on a Windows Server that is currently in Azure cloud using the information from this blog post ...
2
votes
3answers
220 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
0
votes
0answers
5 views

Percona: What are the implications of changing repl.commit_order?

I'm currently doing some trials of Galera Cluster with Percona 5.6. I've progressed to testing a 2 node cluster on baremetal. With repl.commit_order set to 0 (off) the TPS performance as measured with ...
0
votes
5answers
972 views

mysql replication stop/start causes duplicate rows

We're using pretty simple MASTER->SLAVE MySQL query-based replication. Every midnight a cron script on the slave stops the replication SQL_THREAD, backs up the slaves databases with mysqldump and ...
0
votes
7answers
30k 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 ...
1
vote
2answers
1k views

Heavy write to Galera cluster - table locked, cluster practically unusable

I set up Galera Cluster on 3 nodes. It works perfectly for reading data. I have done simple application to make some test on the cluster. Unfortunately I have to say that the Cluster fails totally ...
0
votes
0answers
16 views

MariaDB Remote MySQL Connections

I am trying to allow multiple people to remotely connect to my MariaDB MySQL server. I'm assuming it works the same way widely across any MySQL server as I can personally connect to it from my home ...
2
votes
1answer
6k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
0
votes
3answers
119 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
0
votes
4answers
691 views

Rebuilding corrupt slave by copying mysql folder

Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing? master mysql> SHOW MASTER STATUS\G (take notes) slave ...
0
votes
1answer
431 views

How to fix MySql server in wamp that is not able to display the table with INNODB engines?

MySql server can display all the tables with MyISAM engines but cannot able to display the tables with INNODB engines, but if I can make the tables with INNODB engines it can still show that tables, ...
0
votes
1answer
33 views

How to login to a server as a mysql user in order to stop the mysql server?

I have a linux server instance hosted by RunAbove where I log in as an 'admin' user using an ssh key. I need to change the mysql root password on the server manually. I'm following directions given ...
0
votes
1answer
58 views

Mysql crashed showing following errors. Is this a hack?

2015-05-17 14:50:38 1896 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: No such host is known. 2015-05-18 00:11:23 1896 [Warning] IP address '222.186.21.38' could not be resolved: The ...
-3
votes
1answer
37 views

Not able to install MySQL server on CentOS 6.6

I tried this following command [root@n yum.repos.d]# rpm -qa | grep mysql mysql-libs-5.1.73-3.el6_5.x86_64 mysql-community-release-fc21-5.noarch [root@n yum.repos.d]# But I give followed ...
1
vote
3answers
1k views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
0
votes
2answers
28 views

User with grant permissions cannot grant permissions for new user with and new database

I am using: mysql 5.5.43-0 on ubuntu 14.04.1 I try to create a new admin-user (admin) who is allowed to do the following things: a creating new users (dbuser1) with password - (permission "create ...
0
votes
2answers
989 views

Cannot drop index from MySQL INNODB table with foreign keys/references

I'm about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says: 1025 - Error on rename of 'X/#sql-2a5f_219828' to 'X' (errno: 150) ...
0
votes
1answer
27 views

MySql Clients connection timeout randomly

I have 100 PC clients connecting to MySQL over LAN. They're running INSERT querys with no particular period.Statistically, at the same time no more than 10 PCs are trying to run INSERT query. This is ...
-1
votes
2answers
41 views

how to extract mysql version by bash script in centos 6

I need to extract the mysql version in a bash script on CentOS 6 for a minimum requirements check Example: # mysql -V mysql Ver 14.14 Distrib 5.5.43, for Linux (x86_64) using readline 5.1 # mysql ...
-2
votes
2answers
35 views

RAM usage by Apache server in Wordpress Site

I need some advice as I have a VPS OpenVZ with 1GB Ram and 1GB burstable. I am running a site on wordpress and my site users are about 2000 per day. My DB size is about 90MB and I am using latest ...
-3
votes
1answer
24 views

phpMyAdmin and roundcube web mail error - Cant log in [on hold]

I'm having an issue logging into the roundcube and phpmyadmin. I get an error just shows up with code. I run Centos6 on my VPS. I cant pin point the problem. Here are some screenshots of the errors: ...
-1
votes
0answers
86 views

new pp for JIRA<>mySQL

Getting "Error: Could not retrieve catalog from remote server: Error 400 on SERVER: Could not find template 'jira/etc/rc.d/init.d/jira.erb' at ...
0
votes
1answer
15 views

What is the next step to take when receiving this mysqldiff error?

I have a MySQL database that has been in production and saved and restored a few times with phpmyadmin and mysqldump/restore. I suspect the "production activity" has introduced some discrepancies ...
0
votes
0answers
19 views

MySQL: Show only 1 record which is less than or equal [closed]

I want to filter my table for a specific value. There should always the next lower value be shown. +----+-----------+-------+------------+ | id | productid | lvl | value | ...
0
votes
3answers
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am facing this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I tried every thing I found on Internet, but can not solve the ...
0
votes
2answers
903 views

Connections to host are sporadically successful with mysql_connect() and telnet, but I can always ping the host successfully?

When I try to connect to a host on my LAN with mysql_connect();, the connections succeed some of the time and fail at other times. I can always ping the MySQL server successfully, but when I try to ...
1
vote
2answers
1k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
-3
votes
1answer
162 views

Which one is better ? one big server or two small servers for mysql and apache? [closed]

I am moving my small phpBB website from a hosting to cloud (digitalocean) the size of my mysql server is 400MB, and I wonder if I should buy one big server for my site or two small servers ? let say ...
1
vote
0answers
57 views

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) [closed]

I am using MySQL with PHP for printing details from Database. As i tried to make a new user which was successful though but, i had error from MySQL when i tried to fetch data from it , it showed me ...
0
votes
1answer
16 views

Ubuntu broken machine (backup mysql via FTP)

I cannot access my virtual machine (ubuntu 14.04). The only way to connnect is via the FTP. I really need to backup all mysql databases from there. Is this possible to just copy the whole mysql ...
8
votes
2answers
3k views

Mysql Slave stuck in “System lock”

My MySQL slave is spending a lot of time in Slave_SQL_Running_State: System lock. I can see that the system is currently I/O write bound, and that it is processing the log, although slowly. Show ...
0
votes
2answers
1k views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
0
votes
0answers
14 views

RDS MySQL A B replicate across continents?

I have a web app that I run for Australian customers hosted on AWS using RDS. Can I bi-directional replicate in realtime the database to the USA and Europe AND expect to be able to have a single ...
1
vote
2answers
3k views

MySQL Error on Startup: ambiguous option '--log=/var/log/mysqld.log'

I would like to try MySQL 5.6 on my machine, but I cannot start it. I always get an error : [ERROR] /usr/local/mysql-5.6.5-m8-osx10.6-x86/bin/mysqld: ambiguous option '--log=/var/log/mysqld.log' ...
0
votes
1answer
37 views

mysql error when running script to dump all databases

I am having mysql server in centos which is running fine, i recently got a script to dump all individual databases to one folder, when i run that script to dump, i'm getting this error when ever i run ...
2
votes
0answers
24 views

combine two mysql replication log files

So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
0
votes
1answer
20 views

How exactly date/time works in MySQL with timezones?

My understanding was: everything is UTC internally dates are displayed in @@session.time_zone timezone for current session if I do INSERT with +02:00 TZ set and insert 2015-05-15 10:54 it is parsed ...
1
vote
3answers
2k views

MySQL-5.5.10 - Lost connection to MySQL server during query (Both Web Clients and MySQL Slaves)

We've just upgraded our existing MySQL5.1 DB servers to newer (much better) hardware with MySQL 5.5, and things have been going mostly smoothly for almost 6 weeks. Just the last few days, I've ...
0
votes
2answers
40 views

Python Pip Install fails - Could not build the egg. Also cannot use 1.2.5 because of google cloud sql

I need mysql-python. I get error of could not build egg while installing 1.2.4 Everywhere it says install 1.2.5, which works for me too. But googleAppEngine's app.yaml supports only 1.2.4 ...
1
vote
1answer
101 views

MySQL Workbench with Debian Jessie - TCP/IP over SSH does not work

I use to connect with Windows 7 Pro x64 to my MySQL server hosted on a Debian Wheezy with the MySQL Workbench client using the "TCP/IP over SSH" but it does not work on my new server on Debian Jessie, ...
0
votes
1answer
22 views

Puppet - mySQL not remotely accessible upon setup (workbench)

I used Puppet's mySQL module to bring it up like this. The workstation ip is 172.16.1.49 and JIRA(mySQL) VM is 172.16.1.47 (Puppet Master is 172.16.1.80); I'm trying to access mySQL server using ...
-1
votes
0answers
9 views

Plesk Windows mysql root access denied even with correct password [closed]

I am using Plesk on Windows Server. I just want to login to mysql as root. I get the password as stated in here. I get the password and I am sure this is the correct password. But I get access denied ...
-1
votes
0answers
49 views

SSH Connection is established on port 22, but service is not working [migrated]

I am having this recurrent issue on one of my MySQL Cluster Servers, actually always happens in any random MySQL server of this cluster, on many countries where we have this same configuration. I ...