MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
38 views

MySQL root password not working as expected

I am running MariaDB 10.0.24 on Ubuntu 16.04. I installed it via the xenial repo apt-get install mariadb-server. The root password doesn't seem to be working properly. I ran through these steps to ...
-1
votes
2answers
40 views

Linux init script service - delay until mysql socket is ready

How does one go about delaying a service init script in Linux until the MySQL socket exists? Does the sleep command in a startup script delay the entire boot process, or are init scripts each ...
-1
votes
2answers
45 views

Removed ib files to make mysql start but now it does not recognize tables

I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database ...
0
votes
1answer
13 views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
1
vote
0answers
12 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 ...
0
votes
1answer
29 views

When Dealing with Databases on Docker

I've been using docker locally for a while and one of the issues I've had is when, inexplicably, the docker container dies and it takes all the data with it. Obviously, this can not happen in ...
1
vote
1answer
39 views

How to completely remove volumes/instances from OpenStack Kilo database

We're having some troubles deploying Kilo on a system with 3 controllers and 3 computes, through mirantis fuel 7.0. The problems involve creation and attaching of volumes, specially the ones stored ...
1
vote
0answers
14 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
0
votes
0answers
9 views

Fatal error: Call to undefined method mysqli_stmt::get_result(), Mysqlnd enabled [closed]

I am getting this error Fatal error: Call to undefined method mysqli_stmt::get_result() only on server. The phpinfo http://gerakas-forest.gr/info.php The Mysqlnd is already installed and working. ...
0
votes
1answer
14 views

importing self signed certificates mysql/mariadb and tomcat how to?

trying to use certs for securing connections between Tomcat 8.x and mysql/mariadb. I'm going to use a self-signed cert. What follows is what i think i should be going and appreciate you to jump in and ...
0
votes
1answer
25 views

Can't mysql_secure_installation a fresh MariaDB on fresh Ubuntu 16.04 LTS

I am trying to run mysql_secure_installation on a fresh install of MariaDB on a fresh Ubuntu 16.04 LTS server. I installed via the exact instructions found here. When prompted for Remove anonymous ...
-1
votes
0answers
9 views

Mysql Dump and exclude a bunch of tables via a wildcard

I've searched and couldn't find a clear answer to go about doing a mysql dump excluding a bunch of tables using a wildcard. I know mysql has the --ignore-table option, but I would have to list out ...
1
vote
1answer
36 views

MySQL server experiencing high stress/max connections

The Short: We're hitting max connections and seeing very poor performance from MySQL during peak business hours and cannot determine if it is a load problem or a configuration problem. The Long: To ...
1
vote
1answer
15 views

Yum dependency available but not marked for install

I'm trying to install a specific version of MySQL: mysql-community-server-5.6.29-2.el6 on RedHat 6.6. When I run yum install, I get dependency errors, but the dependencies are clearly available. I'm ...
0
votes
0answers
8 views

mysql ndb cluster - Management node and data node go down together

I have an NDB scenario with the following details: Blade 1: VM 1 : Management Node (Active) VM 2 : Data Node VM 3 : SQL Node Blade 2: VM 1 : Management Node VM 2 : Data Node VM 3: SQL Node If ...
-1
votes
0answers
19 views

Beginner explanation on MySQL cluster? [closed]

I am a beginner on MySQL and so far I have a web application with only one MySQL server running. I want to add more MySQL servers and started to read about MySQL clustering, but have a problem with ...
-2
votes
0answers
21 views

MySQL optimization suggestion? [closed]

I have a digital ocean vps with 2gb ram, 40gb ssd, 2x intel xeon 2ghz. My mysql stops at random times. this is my confoguration: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock ...
0
votes
1answer
19 views

php-cgi.exe CPU load jumps after MySQL Backup

I'm running Windows 2012r2 on a new server, with Plesk 12.5 and MySQL 5.6 installed. There's a backup script which takes a DB dump and zips website data files that runs each day. However, it brings ...
2
votes
1answer
1k views

Ubuntu upgrade from 14.04 LTS to 16.04 failed - mysql-server-5.7 dependecies fail

I am trying to upgrade existing Ubuntu 14.04 LTS to Ubuntu 16.04 LTS and it seems I am stuck somewhere in the middle. When I turn on my workstation, I get Ubuntu 16.04 LTS welcome & login screen, ...
0
votes
1answer
54 views

mysql_upgrade - ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

After backing up my Plesk (12.5.30) server, I received the following error: Not all the data was backed up into /var/lib/psa/dumps/domains/example.com/databases/example_database_1 successfully. ...
2
votes
3answers
25 views

How to escape a - in a table name in mysqldump

If I want to exclude a table in a schema which contains a minus -, how do I escape that in mysqldump? Or do I not need to? mysqldump --ignore-table=foo-bar.tl_log does not seem to work
0
votes
2answers
36 views

MariaDB dying regularly

I've recently switched from MySQL do MariaDB to host WP website. Everything was smooth and I even noticed speed increase (which might be just placebo ;). From then on though MariaDB started dying ...
1
vote
2answers
71 views

Failed to start MariaDB database server

Since / partition is only 50G, and my data is larger than that. And there are 500G space in /home. So, I move all the data of MySQL into /home. The following are my steps(under root account): shout ...
0
votes
0answers
32 views

MySQL server is unreachable from OpenVZ container

Writing out of despair. Yesterday, as usual and having done this for thousands of times before, I'd installed MySQL server in the Head Node for using it from the OpenVZ container. I've created user, ...
0
votes
0answers
23 views

Zabbix Can't Connect to MySQL

I just install zabbix-server on my server with MySQL running on it. I follow step from official website. And finished well. Then i try to access its page using http://my-server-IP/zabbix but it shows ...
1
vote
1answer
18 views

MySQL 5.7 Failed to update target: In aggregated query without GROUP BY this is incompatible with sql_mode=only_full_group_by

MySQL 5.7.8rc Ubuntu 14.04 I have modified the my.cnf to add this line: sql_mode = ...
1
vote
1answer
12 views

How to exclude specific table from innodb buffer pool?

Here's my situation. I have one really large table that holds about 90 GB of data. I've utilized DATA DIRECTORY to place that table on another drive, as I rarely use the table and don't want it ...
0
votes
1answer
21 views

Debian Jessie mySQL 5.5 upgrade to testing 5.6 issues?

I need to upgrade from stable mysql-server5.5.x to 5.6.x on Debian Jessie to run Magneto, but I am also running a high volume forum on 5.5.x. If I enable testing repos and pull 5.6.x (currently ...
0
votes
1answer
47 views

How to tune MySQL server when big peak of usage is expected

I'm having pretty big issues trying to tune my MySQL server. I was expecting a lot of people on my website after buying a tv ads between 5pm and 6pm, I have more or less 300 persons at the time on the ...
0
votes
1answer
36 views

How to disable ssl plugin on MySQL 5.7 server?

New introduced SSL connections on MySQL Server is now default installed on CentOS 6.7 default rep. Just removing the certificate files can solve it accoding with Docs: "If the server does not ...
0
votes
0answers
14 views

Configure auth with MySQL in Apache 2.22

I've got a raspberry pi 1 which serves web pages using apache 2.22. I've done some research and I found a way to secure "pages" using a database (mysql in this case). I've found this little guide to ...
0
votes
1answer
55 views

VPS Server getting offline - CentOS

I have a VPS CentOS Server hosted by GoDaddy. The database for my website is going down once everyday. I have two websites hosted on that server, a Wordpress and a Magento website. The connection to ...
-1
votes
0answers
39 views

Installing mysqlnd for php 5.6 on CentOs 7

I get php warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50547 Library:50624 Also I read that I need to install mysqlnd to my server. I tried do it using: ...
-2
votes
2answers
27 views

Create a non root user for Linux MySQL with minimal right as using root is not secure

General rule for root MySQL user is from security point of view: "Do not use root for any web application for MySQL connection, Select, Update, or Delete queries. Instead of create and use another ...
-3
votes
1answer
81 views

I think I'm Hacked. MySQL Server Too Many Connections Made my Server CPU load 100% [closed]

I'm having a very urgent problem. Suddenly today My Server can't send email, after i checked out the log turns out there are many errors from MySQL which says too many connections. I checked out my ...
0
votes
0answers
44 views

ownCloud 9 MySQL not supported

I'm trying to install ownCloud 9 to FreeBSD 10 with nginx as web server. I am using this official manual, which tells me to use this command: sudo -u www-data php occ maintenance:install --database ...
4
votes
1answer
406 views

Can I tell MySQL to store specific databases in specific folders?

Lets say I have 2 databases, "foo" and "bar", and I want MySQL to store "foo" in "/media/foo", and "bar" in "/media/bar", can this be done in MySQL 5.5 or later?
0
votes
2answers
49 views

Accessing MySQL Remotely - Best Practices

Sorry if this is a bit of a broad question, but are there any best practices regarding accessing a remote MySQL via remote desktop versus locally through some other method? The goal here is to access ...
-2
votes
1answer
34 views

Running on two servers vs. one with more memory? [duplicate]

I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a ...
0
votes
0answers
28 views

My wordpress/MYSQL is consumming way too much memory, how do i act on it?

I have a Ubuntu server running apache + mysql + PHP +postgres + passenger Mysql is often crashing, putting wordpress out of service. I asked the question here : Wordpress + PHP+ apache +mysql, mysql ...
-1
votes
1answer
40 views

Wordpress + PHP+ apache +mysql, mysql crash every 1/ month [duplicate]

On a server i have multiple rails apache + postgres apps and a mysql + php. The only PHP app is a wordpress. Except for wordpress everything runs fine. Every 40-50 days, mysql stop to work. Here is ...
0
votes
2answers
45 views

MySQL stopped running on Ubuntu: Can't change to run as user 'mysql'. How to save data?

Today out of the blue stopped running MySQL on a Ubuntu server. When I try to log in there, I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
13 views

mysqldump --databases option vs .my.cnf inconsistency

I had an issue which another serverfault issue solved, however, I'm trying to understand WHY. This issue is here: Mysqldump complains about chosen databases regardless of command line, and the ...
0
votes
0answers
12 views

MySQL not creating tables automatically when JAMES APACHE is started

The programs I am using: JAMES Apache Server 2.3.1 binary MySQL Workbench 6.1 CE MySQL Connector 5.1.38-bin.jar in ~/james/lib OS: Windows 10 64-bit In james 3, I am able to create MySQL ...
1
vote
1answer
38 views

Get mysql last uptime

I just restarted the MySQL service. I know how to get the current Uptime, but by any chance is there a way to get the uptime before last restart ? Thanks
-2
votes
0answers
14 views

Backup mysql databases from ubuntu server into windows laptop scheduled

I have installed webmin to backup mysql server into a directory on /home/serveronit/mysql-backup and it works in my ubuntu. This ubuntu is on 192.168.5.225 This is the list of file ...
1
vote
0answers
25 views

have xmpp (ejabberd) server authenticate with existing user database (MySQL)

Let me start off by stating that I know very little about the XMPP protocol or real-time communication in general. I did however manage to set up an ejabberd server with TLS encryption. I have written ...
0
votes
3answers
30 views

Backing up MySQL MyISAM databases by copying the physical folders

I have a Windows Server 2008 R2 machine and on it I have 2 MySQL MyISAM databases. These databases are quite large as they are over 20GB in combined size. I update these databases once a week. (I ...
0
votes
1answer
40 views

Windows server 2008 R2(standard) client connection is very slow after connecting above 24 client machines? Is there any client connection limit?

Windows server 2008 r2 standard is connecting 24 cilent machines after while adding extra machines to server it gets slow. In Windows server 2008 r2 maintaining the mysql database and all other client ...
0
votes
0answers
6 views

MySQL in WAMP for Commercial App [duplicate]

I have a java application that connects to a MySQL database. My question is, is MySQL in WAMP free to use in a commercial application? Do I have to pay for MySQL license?