MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
38 views

mysql: relocation error after installing in centOs?

I remove any mysql package and now after installing mysql after type this command mysql -u root -p this error occured: # mysql -u root -p mysql: relocation error: mysql: symbol strmov, version ...
-1
votes
1answer
87 views

Can't install mysql in centos6.4

When i try to install mysql 5.6 and i remove mysql 5.1 from centos now not installing any mysql in my VPS. yum install mysql-server Loaded plugins: fastestmirror, refresh-packagekit Setting up ...
0
votes
1answer
30 views

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages?

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages? I want to have both servers running in the same machine, using different listening ...
-1
votes
1answer
44 views

Unable to import dump.sql via a .sql file which will be run through mysql command line

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
0
votes
0answers
13 views

Web Based Server Monitoring and Alerts For In-house server [duplicate]

I'm currently working on a project that has an in-house set of CentOS 6.5 servers for both Apache and MySQL. What happens is that it doesn't have a monitoring system so, if it happens for the server ...
-1
votes
1answer
45 views

Error when setting up mysql cluster

I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error: 2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
0
votes
1answer
104 views

MySQL/MariaDB stops running. How do I find out why?

Today I've seen MySQL/MariaDB stop running on a CentOS VPS. When I check the status I get: # service mysql status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists So I ...
1
vote
1answer
35 views

MySQL Replication Logs Filling Partition

We have MySQL replication setup from site-to-site. The slave is just a backup used for reporting etc(No write). Everything is going well as far as I can tell. However, the server is quickly running ...
1
vote
0answers
86 views

R1Soft MySQL Failed to perform discovery on database instance

I am using R1Soft (5.8.1) for file backups on a few servers and have tonight been trying to setup a MySQL backup - I installed the driver etc and am setting up the policy but am getting an error. ...
0
votes
2answers
111 views

Tunnel Connection Error with Mysql Workbench (Host key does not match)

I have an issue with Mysql Workbench which is probably a bug. I'm using EC2 with elastic IPs. I changed my server, but kept my keypair and IP the same. So it should connect as usual via SSH tunnel. ...
0
votes
3answers
335 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I've developed a website on the Silverstripe framework and deployed this to a digital ocean server using centos (7.0.1406) , mariadb (10.0.14) and apache (2.4.6). I'm somewhat of a novice when it ...
1
vote
0answers
26 views

PhpMyAdmin and auth_ldap plugin

I have a need to authenticate MySQL users from an LDAP source using the community edition of MySQL Server 5.5. The auth_ldap plugin has been compiled from source ...
0
votes
1answer
28 views

mysql grant select to ONE table on ALL database

I have many tables with the same table structure. I want to create a user which can access one table in all of those databases. We are adding new databases frequently, so a wildcard would be ...
-1
votes
1answer
65 views

Connecting Database Error using Pentaho Metadata Editor

Error connecting to database [SampleData2] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class ...
-1
votes
1answer
44 views

Importing mysql dump from another host, what to keep on the current one?

I will be importing a MySQL dump from another host with lots of DBs in it to the new server I just set up with VestaCP. Since that seems to overwrite everything on the current one should I keep the ...
1
vote
0answers
36 views

Rsyslog won't monitor mysql-slow.log when written to by mysql

I'm going mad. I'm trying to get rsyslog to send log files to logentries.com. This works perfectly until I try to log mysql-slow.log. The config is pretty simple module(load="imfile" ...
0
votes
0answers
162 views

Configuring SSL connection to RDS using mysql workbench

I connected to my RDS db using MySQL Workbench. However, SSL is not active on the connection. When I force SSL, it fails. Config is default. To enable SSL configuration, Mysql Workbench asks for the ...
-1
votes
1answer
71 views

How to release the physical and virtual memory used from the mysql server? [closed]

Several php scripts are executed from cron on my CentOS 6.5, every php script contain database requests. Depending on the php object size and type the database requests can allocate too much memory. ...
0
votes
1answer
117 views

Cacti Debian 7 Virtualmin , Cannot connect to database

So after installing cacti via apt-get it does not connect to the mysql database it creates during setup, with the error: FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you ...
1
vote
1answer
19 views

WebServer - moving MySQL to another server on LAN for gaining more processing power?

I have website with high traffic hosted on dedicated machine. This machine running out of resources. Will moving MySQL database to another dedicated machine on LAN give more resources to website ...
-1
votes
1answer
38 views

Correct packages to install LAMP on ubuntu

I have read some tutorials about install LAMP and I have seen that they install differents packages for MySQL and PHP. For example to install MySQL: 1. mysql-server 2. mysql-server ...
0
votes
1answer
44 views

mySQL issue at installation

I have great trouble with mySQL installation. The error message in log (/var/log/debug) is: Nov 20 11:17:41 gotfarm1 /etc/init.d/mysql[11880]: 0 processes alive and '/usr/bin/mysqladmin ...
-4
votes
1answer
35 views

Guidance for mysql 5.6 install on Ubuntu 14.04 [closed]

I have followed the instructions at http://dev.mysql.com/doc/refman/5.6/en/linux-installation-debian.html to a T twice now and twice it appears it hasn't worked. There is no my.cnf under /etc, there ...
0
votes
1answer
13 views

Minimizing Downtime With Upgrades For 3rd Party Products

I am currently maintaining a Review Board server (https://www.reviewboard.org/) and one of the big pain points is scheduling upgrades. Currently the process is: Take the server down and send all ...
0
votes
1answer
41 views

MySQL - Why are there three root users with different hosts? [duplicate]

I'd love to know why when you first install MySQL on a server there are three root users entered into the users table each with different host addresses. One with localhost one with 127.0.0.1 and one ...
1
vote
0answers
162 views

Error missing systemd on AWS server

I cant seem to figure out how to install systemd. I am attempting to upgrade mysql server on AWS from 5.5 to 5.6. I am getting the following error when trying to install- "Requires: systemd" Any ...
0
votes
1answer
473 views

Centos/directadmin Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I get the following error on my CentOS VM with DirectAdmin. What I already tried: ...
0
votes
1answer
36 views

Set MySQL innodb buffer pool size on IIS7

I am using VPS, Windows 2008 r2, IIS7, MYSQL 5.1.73, Hardward Config: Ram 2GB , Hardisk 40GB On this VPS only 1 .NET application is running. Application is currently using by only 5 users. I found ...
0
votes
0answers
61 views

Installing mysqludf library on CentOS x64

I've been googling a lot about the problem that I have trying to install MySQL library. I've downloaded library files from https://github.com/mysqludf/lib_mysqludf_sys and placed it on digitalocean ...
-2
votes
2answers
35 views

How to work on 2 MySQL databases at the same time using PHPMyAdmin through Plesk? [closed]

I am trying to open 2 instances of PHPMyAdmin by clicking on the "manage database" link in Plesk. But the challenge is I seem to be only allowed to work on 1 database at a time as when I try and open ...
0
votes
1answer
32 views

Connecting to mysql with SUPER user when reached Too many connections

The documentation says that: mysqld actually permits max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege ...
0
votes
0answers
49 views

Bottle neck of nginx?

I'm using nginx as a load balancer on amazon ec2 m3.large instance. This load balancer will receive loads from a load generator and distributed them to the 3 instance with mysql database serves as ...
0
votes
0answers
54 views

auto-provisioning mySQL via WHMCS

I'm trying to use the WHMCS API / provisioning module to auto-create a mysql database for a new WHM / cPanel client after their order for hosting goes through. It seems like it should be simple ...
3
votes
3answers
153 views

server's memory taken up almost to 8GB

Lately, our server face problem with the memory. Started from few weeks ago, our server was loading very slow. Accessing emails and websites were really take too long. Then we asked the server ...
0
votes
1answer
93 views

Remote Connections Mysql Ubuntu - bind address failed

I am trying to configure my server to allow remote connections. From what I understand I need to uncomment bind-address 127.0.0.1 in the my.cnf file, then restart mysql. That hasn't worked. I have ...
3
votes
1answer
96 views

High CPU on MySql Fusion-io server

I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication. MySQL ...
1
vote
0answers
130 views

mysqld shuts down every 10 minutes

I have a very odd problem: mysqld shuts down every 10 minutes, without any errors, just like some process actually calls "shutdown" on it. I already checked cron, but couldn't find anything there. ...
0
votes
1answer
31 views

How can I log information specific to the “Too many connections error” in mysql

When the Too many connections error is thrown does mysql log that somewhere so later I can see what caused the error? I know I can use commands like "SHOW ENGINE INNODB STATUS" and "SHOW PROCESSLIST" ...
0
votes
1answer
59 views

High Load Website. how to load balancing? [closed]

i have the following problem: i have two servers (intel xeon 3,4 GHZ with 32GB RAM and RAID 10 (4x1TB Enterprise Harddiscs). all servers are installed with vmware esxi 5.5 (free). webserver, ...
0
votes
2answers
226 views

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ ...
0
votes
0answers
56 views

MariaDB, ARIA, “File size bigger than expected”

On (only) my production server, whenever I wait a while and restart MariaDB, it completely crashes and burns, e.g.: 141110 16:18:26 [Note] /usr/sbin/mysqld: Shutdown complete 141110 16:18:26 [ERROR] ...
0
votes
1answer
73 views

Nginx Load Balancer Optimum Specs

I have 3 Nginx servers and each of them should handle about 2k users (concurrent connections). In front of them I have Nginx load balancer. That's 4 Virtual machines, sharing same subnet and same ...
1
vote
1answer
48 views

Mysql optimize one table in all databases

I see in the mysqlcheck manual that there's an option for --tables that overrides that databases option, but it isn't well explained. I'm trying to run mysqlcheck -o and I want it to optimize a ...
0
votes
1answer
36 views

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
1
vote
1answer
130 views

MySQL and SSL with -sha256

I'm trying to create some certificate to use with MySQL and everything works fine if I use the sha1 algorithm. If I add the -sha256 switch or -sha384 I can NOT connect to MySQL!. I get this error: ...
-1
votes
2answers
81 views

How to allow all clients access to remote MySQL server? [closed]

So I followed this guide to gain remote access to a MySQL server for my laptop. However, my IP changes and I want to be able to access the server outside my network. How can I allow any client IP ...
0
votes
0answers
38 views

AWS: RDS instance(s) and connecting from remote machine

I'm moving a site over to AWS. It's on the Amazon-flavored Linux distro, using MySQL. I vaguely remember setting it up a couple of months ago (been busy), and allowed access from my elastic IP. I ...
0
votes
1answer
35 views

Percona Server & MySQL server on the same server on different ports

I have MySQL installed from ports, running and listening on port 3306. On the same server I have Percona Server compiled from sources, running and listening on port 3307. Here are the process list ...
0
votes
1answer
43 views

MySQL replication shuts down after rotate of binlog

I have following issue. I had successfull setup of master-replica(row-based). It has been running for 2-3 hours. After bin-log was rotated -> mysql-bin.index file got corrupted on master. Here is ...
0
votes
0answers
34 views

can't run mysql server (Can't create/write to file '/run/mysqld/ibmW5ibS')

I am trying to run mysql and getting the following: 141107 8:48:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future ...