MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
9 views

MySQLi on Windows Server 2012 [on hold]

I installed mysql and php on Windows Server 2012 R2. I enabled mysql and mbstring in php_production.ini and php_development.ini, but when try to use it from php, i get: Fatal error: Call to undefined ...
-3
votes
0answers
14 views

What is the infra of a windows Azure "site [on hold]

When I make a site on Windows Azure, what is it over?, I imagined IIS and SQL. There is no chance to choose like when you make a VM. Is it possible to make it on top of Apache and MYSQL?
0
votes
1answer
23 views

Allow port on firewall for internal network

I am trying to setup a Percona Galera Cluster but connection over port 4567 fails but port 3306 works. This is how it looks like on the servers Server percona1: netstat -lptu | grep mysql tcp ...
0
votes
0answers
8 views

MySQL Server 5 with Galera on Debian [on hold]

i have installed Debian 7.7 with mysql-server 5.5.34-25.9 and galera 25.2.9. all working fine, my Cluster is running perfectly. for load balancing i use ha_proxy. now i have a few questions: 1) if ...
0
votes
1answer
21 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
14 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
16 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
2answers
38 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
8 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
18 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
10 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
28 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
15 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" ...
-1
votes
0answers
15 views

Linode Mysql_db alrt [on hold]

Your Linode, mysql_db, has exceeded the notification threshold (90) for CPU Usage by averaging 135.6% for the last 2 hours. The dashboard for this specific Linode is located at: ...
-3
votes
0answers
23 views

Correct configuration for mysql server on an AWS EBS LVM volume [on hold]

I have done extensive research on the web to be able to get a mysql server running on an ebs volume with lvm enabled. I had some difficulties but which I've overcome. However before I rest on my ...
0
votes
0answers
11 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
31 views

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

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
7 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
votes
0answers
23 views

Connection failed to MySQL server? [on hold]

My website runs on a cPanel server that I have root access to. About once every 2-3 hours I get an error message saying that the website can't connect to my MySQL database. The website and database ...
0
votes
1answer
16 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
17 views

Frontend executing PHP page stopes other PHP pages from working? [closed]

I have VMware workstation with Turnkey Linux LAMP, but i had this problem in the past many times so don't think its related to server architecture. I have site setup example1.com where i have 2 PHP ...
-1
votes
1answer
16 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
33 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 ...
-1
votes
0answers
13 views

unzip file and import it on the same line [duplicate]

I upload a gzziped file that contains an sql file, I would like to extract it and use it in the same line so I don't need to delete it later. steps: - I upload a file the web interface - in my code I ...
-4
votes
1answer
14 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 ...
-2
votes
0answers
62 views

MySQL any way to import a huge (32 GB) sql dump faster? [migrated]

I have this huge 32 GB sql dump that I need to import into MySQL. I haven't had to import such a huge sql dump before. I did the usual: mysql -uroot dbname < dbname.sql It is taking too long. ...
0
votes
1answer
6 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
33 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
votes
1answer
31 views

access MySQL connection from outside LAN [closed]

Currently I have a scenario like this: I develop desktop application that connect to mysql using public IP. There are 2 servers, Mysql DB server with only LAN IP (ex: 192.168.0.3) and Application ...
1
vote
0answers
33 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 ...
-7
votes
0answers
31 views

Synchronisation between AD & MySQL server [duplicate]

I would like to know if there is a way to synchronise a MySQL's database to a AD. By exemple the user created in MySQL's database is sychronized to the active directory and vice versa. And if it's ...
0
votes
1answer
81 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: ...
-1
votes
0answers
7 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
17 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 ...
-1
votes
0answers
13 views

Table not converted in Owncloud migrating from SQLite to MySQL/MariaDB

In Owncloud database migratiion from SQLite to MySQL/MariaDB I have been prompted for the following question... # php occ db:convert-type --all-apps mysql owncloud_user 127.0.0.1 owncloud Creating ...
-2
votes
2answers
18 views

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

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
19 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
43 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
24 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
136 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
24 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
58 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
43 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
0answers
4 views

Does the order of a mysql multi-column MySQL index matter - if you're always using all columns in the query? [migrated]

I'm aware that when you define a MySQL index that the order of the fields matters if the query is only using part of the index, as described here. But if your query is always going to use all columns ...
0
votes
1answer
22 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
41 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
115 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 $ ...
-1
votes
0answers
24 views

Do i need reindex mysql table after bulk delete? [migrated]

I have a table in mysql with a lot of INSERT and SELECT at every second. And there is a bulk delete of some older data once in a day. Do I need to reindex the table after delete? I want to increase ...
0
votes
0answers
19 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
37 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 ...