MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
3answers
89 views

Separating mySQL server from LAMP and performance degradation

I'm currently using LAMP stack (over Centos 6.5) for our sites, and I want to try separating the mySQL from the "web server". Until now I was using DigitalOcean's VPS with quad core CPU and 8GB of ...
-1
votes
0answers
26 views

Site returning Database connection error after second visit - Must restart httpd

I am running CentOS release 6.6 and have been running a wordpress site for over 2 years. From 1 week ago my site displays the following message(bear in mind I didnt login or change anything for it to ...
0
votes
1answer
1k views

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
0
votes
0answers
4 views

How to export views and import it in other DB? [migrated]

I am trying to export the database and everything is fine but I am not able to export the VIEWS. Is it possible to export the views from sql queries and import it?
2
votes
1answer
106 views

MySQL 5.7 bind-address doesn't work

I have always successfully set up a remote connection for mysql 5.5. Today I installed a new server with Ubuntu 16.04 and MySQL 5.7. But for some reasons, I can't make this mysql installation listen ...
0
votes
1answer
7 views

mysql out_file default permission

When I use SELECT "something" INTO OUTFILE "/tmp/somefile" in MySQL, the created /tmp/somefile always seem to have the default permission of 0666. Is there a way for me to specify in the query ...
0
votes
3answers
31 views

MySql query returns null on ocassions

I'm not sure what exactly is causing this but on occasions a mysql query that I know has to return results will sometimes return null as a result. I've seen this happen twice before but as I couldn't ...
8
votes
2answers
1k views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is /etc/pam.d/...
2
votes
3answers
3k 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
1answer
36 views

Monit not monitoring LEMP

I have LEMP with MariaDB installed on Ubuntu 14.04. I have Monit installed and configured to monitor php-fpm, mysqld and nginx but non of these services seem to be monitored as shown in the screenshot ...
0
votes
1answer
65 views

Replacing mysql with MariaDB

phpMyAdmin shows this version ! I am new to Linux and servers. I was using mysql 5.5 (was installed using third party repositories) as my DBMS and then I decided to replace it with the latest version ...
1
vote
1answer
36 views

Postfix + SASL using wrong query to authenticate

I recently set up postfix + dovecot on a aws ec2 instance following this guide: http://flurdy.com/docs/postfix/#config-secure-auth Currently I'm stuck with SASL. The SQL query doesn't seem to be ...
0
votes
3answers
1k views

MySQL Memory Limit Windows Server 2003

I am running MySQL 5.0.51a on Windows Server 2003 Standard Edition on an HP DL580 G4 with 3GB installed. One of my database tables has grown to 5.3 GB with an index file of 2.5 GB, which I believe is ...
0
votes
0answers
12 views

How to force rsyslog ommysql use utf8?

I'm using ommysql in rsyslog for transfering data into mysql $ModLoad ommysql local6.* :ommysql:localhost,Syslog,rsyslog,1 but cyrilic data goes like "·Ð¾Ð²Ð°Ð½Ð¸Ðµ иÑ�точнÐ" in ...
-1
votes
0answers
24 views

Updated MySQL on Debian and broke it [duplicate]

Preparing to replace mysql-server-5.5 5.5.46-0+deb7u1 (using .../mysql-server-5.5_5.5.49-0+deb7u1_amd64.deb) ... [FAIL] Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, ...
5
votes
3answers
6k views

Bulk or mass killing misbehaving MySQL queries

How do you kill a mass of MySQL queries? Here is a good approach: mysql> SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root' INTO OUTFILE '/tmp/a.txt'; mysql> ...
0
votes
1answer
8 views

ndbclient native library is missing in Mysql Cluster installation

I'm trying to run ClusterJ which cannot find ndbclient library. In my MySql Cluster 7.4 installation under Windows I have ndbclient_static.lib file in lib catalog. Why ndbclient library is not there? ...
0
votes
0answers
3 views

MySQL cluster installer does not deploy API node

I'm trying to install MySQL cluster 7.4 from windows machine using MySQL Cluster Installer. It deploys and starts data, mysql and management nodes. But API node is left undeployed (UI indicating red ...
0
votes
2answers
3k views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
1
vote
1answer
1k views

MySQL Extremely High Disk Activity (Read Operations)

I have 1GB Linode VPS with a standard LAMP stack. Apache is tuned fine but for some reason MySQL's disk usage is high. This is causing really slow site load times. RAM and CPU usage are fine. Can ...
2
votes
3answers
3k 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 ...
1
vote
2answers
5k views

Issue Starting MySQL Daemon

I have just come across the most random error I've seen my MySQL daemon spew out yet, everything was working fine, then all of a sudden it randomly crashed and it now outputting this when I start it ...
0
votes
2answers
4k views

Enabling phpMyAdmin Designer Mode

I've been trying for hours to enable phpMyAdmin Designer Mode on a CentOS cPanel dedicated server with no luck... here's the steps I followed, perhaps I'm missing something? I created the pma user ...
1
vote
2answers
1k views

large number of InnoDB tables plus SHOW TABLE STATUS

We've got several hundred InnoDB tables in a database, and we use phpMyAdmin to manage them. Unfortunately, phpMyAdmin does a SHOW TABLE STATUS query whenever the list of tables is shown, and this ...
0
votes
1answer
31 views

MySQL Replication Errno1146 Table doesn't exist

Here's the setup: I have a MySQL DB cluster in Rackspace that I'm already using for replication to multple slaves in multiple datacenters. I am trying to use AWS' Aurora with a MySQL front-end, which ...
0
votes
1answer
51 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and (...
9
votes
4answers
2k views

Can OpenSSL be used to debug an SSL connection to a MySQL server?

I want my webserver to speak to the MySQL database server over an SSL connection. The Webserver runs CentOS5, the Database Server runs FreeBSD. The certificates are provided by a intermediate CA ...
-1
votes
0answers
16 views

php with mysql and IIS not working

I have followed online tutorials and installed PHP, and pypmyadmin on my windows server but when i am trying to install the mySQL server instance window its just freezing on "prepare configuration", ...
30
votes
8answers
53k views

How can I copy MySQL users table from one server to another?

I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away). Would it work to just do a dump of ...
1
vote
2answers
837 views

Uninstall Mysql 5.7 from Ubuntu 16.04

I am having problems with mysql 5.7 in ubuntu 16.04 when it comes to giving users privileges, so I want to re-install it again but when I type the command for removing mysql I get the following ...
0
votes
0answers
25 views

Connection failed: php_network_getaddresses: gethostbyname failed. errno=0

I need you'r help please... I created php web site in google engine. I open connection to mysql server using appharbor. When i run it local it connect very good and there was no errors in my web ...
0
votes
0answers
7 views

Unable to connect to locally ran SQL DB in Docker Container

I have a mariadb (mysql) running in a docker container with a test db, table and dummy data. I very it's running with docker exec fcd12bf1da81 /etc/init.d/mysql status and it outputs the uptime, ...
0
votes
1answer
53 views

RDS Performance slow compared to local mysql install

I have a RDS server (rd3.medium) on AWS that is running basic configuration. I'm trying to run this query, which runs in a few milliseconds on my local computer, as well as a basic web server where I ...
1
vote
0answers
17 views

Inconsistent CPU load on debian

This server runs Apache2, Tomcat6 and MySQL.(if that makes any difference you tell me :) Using htop i can see the cpu load on each of the 4 cores. What I do not understand is witch processes are ...
0
votes
1answer
32 views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
4
votes
3answers
5k views

MySQL won't start after setting external bind-address

I want to enable remote access to my MySQL server so I've set the bind-address option under [mysqld], which looks like: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql ...
13
votes
4answers
57k views

RSA certificate configured for SERVER does NOT include an ID which matches the server name

I recently started a LAMP server (all the latest versions) w/ WordPress on it, and I'm trying to install a SSL certificate that I recently purchased. When I restart apachectl, error_log gives me this: ...
1
vote
1answer
677 views

Mysqldump not working with SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER privileges

My system: CentOS 6.5 + MySQL 5.6 I have created a backupuser for mysqldump: CREATE USER 'usr_backup'@'localhost' IDENTIFIED BY 'XXX'; GRANT USAGE ON *.* TO 'usr_backup'@'localhost' IDENTIFIED BY "...
7
votes
3answers
4k 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 ...
0
votes
1answer
31 views

shell script for geting mysql user grants details

I am trying to get mysql user grant details and echo it to out file hari=mysql -sN -e "show grants for mysqladm"; echo $hari GRANT ALL PRIVILEGES ON *prod_server_list.txt stage_server_list.txt ...
0
votes
1answer
15 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D <...
0
votes
1answer
76 views

php unable to connect to MySQL via SSH tunnel

I have executed both commands via SSH with no error and than when I try to connect to the MySQL server via SSH tunnel I get no results even if I do a simple query like select * from table. I get no ...
0
votes
1answer
26 views

Windows server 2012 IIS 8 php data post upload failure to mysql

I'm getting a php data upload fail when attempting to transfer data up to a mysql database from a html5/webgl built app off of Unity. All of the data downloads work regardless of the upload issue. The ...
1
vote
1answer
76 views

convert plain text passwords to sha512-crypt in dovecot + postfix's mysql mailbox table

I have an old postfix + dovecot + Roundcube mailserver (mail.domain.Tld). Server clock is loosing time and adjusting it causes dovecot to kill itself, we cannot install more memory, bigger hard-drives,...
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 ...
0
votes
0answers
56 views

MariaDB 10.1.x Online DDL spaming error log files

Since our upgrade to a new mariadb/mysql version (previously the 10.0.x branch) we have tons of this messages in our error log. All of them are a type [note] messages but i cannot find any ...
3
votes
3answers
4k views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
1
vote
1answer
21 views

AWS RDS host instance creation fails: “hardware error”

I'm trying to create a MySQL RDS host instance on AWS (via Ansible) and getting the following error: The database instance has been put into STORAGE_FAILURE due to a hardware failure It happens ...
0
votes
0answers
22 views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

I installed MySql and when i try to start it , it stop with error 3534 here is my error from log 2016-05-19T19:29:20.416636Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql....
0
votes
2answers
102 views

How to detect slow code or plugin

I don't have much experience with WordPress and I don't know where to start. There is a website which is running very very slow. The hosting company helped me to detect that it's because some piece of ...