MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
19 views

phpMyAdmin - #1045 - Access denied for user - However my script still works

The login page on phpMyAdmin does not let me log in and gives me a 1045 - Access denied for user However my php script on the page which uses the exact same login data, still works no problem. ...
0
votes
1answer
20 views

How can I deal with failures when connecting to a MySQL cluster?

Our company has created two MySQL servers that are kept in synch using a master-master strategy. The two-machine cluster is managed using crmsh. This is only a high-availability cluster, meaning that ...
1
vote
0answers
96 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
14
votes
1answer
931 views

PuTTY typing its name into the console

I was doing a MySQL dump over SSH using Putty, and now it is just typing PuTTY over and over again into the console, Ctrl+C doesn't do anything. Does anyone know why this is happening?
3
votes
2answers
412 views

Changing phpmyadmin root password

I'm trying to figure out how to change the root password for phpmyadmin. I've tried doing this a few times using this: $ mysql -u root -p use mysql; update user set password=PASSWORD("NEWPASSWORD") ...
1
vote
1answer
99 views

Overwriting phpMyAdmin

I am using Centos 5.5 and had phpMyAdmin version 2.11.11 installed. I couldn't find a way to update it, so what I did was do a manual download, backed up /usr/share/phpmyadmin, then replaced that ...
1
vote
2answers
1k views

How to grant and revoke rights to tables using phpMyAdmin

Is phpMyAdmin capable of granting rights (permissions) on certain tables to users or roles? When I look at the page of a database table there is no "rights" tab. I have only found a place where I ...
0
votes
1answer
22 views

Can't access mysql docker container from the host

I have a debian server with docker 1.6.0 on it with a running official mysql container (https://registry.hub.docker.com/_/mysql/). I use a fairly basic firewall configuration in which all ports are ...
2
votes
1answer
42 views

99% disk IO spikes with Percona

So we have a server that has seemingly random spikes in disk I/O, going up to 99.x% at random times and for no obvious reason, staying high for ~1 hour, and then going back down. This hasn't been much ...
0
votes
0answers
6 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
votes
0answers
21 views

MySQL fail to add users during installation [on hold]

I'm using Windows 7, trying to install MySQL Server 5.6.24 Community Edition. I've chosen all default options, and given a root password and created 1 user, a DB Admin. At the Apply Server ...
3
votes
3answers
970 views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
0
votes
1answer
1k views

MySQL port 3306 became filtered when configured with Keepalived on Ubuntu server 12.04 lts

I'm configuring two load balancer (lb01 & lb02) with keepalived for my two mysql server (db01 & db02) with standard port 3306. There is virtual ip address (192.168.205.10) to access it also ...
3
votes
3answers
1k views

Monit can't detect MySQL, but I can

Monit is configured to watch MySQL on localhost at port 3306. check process mysqld with pidfile /var/lib/mysql/li175-241.pid start program = "/etc/init.d/mysql start" stop program = ...
0
votes
0answers
9 views

Installation for mysql_config with Percona already installed

I have a CentOS 6.6 installation with Percona XtraDB Cluster client installed on it. This version of Percona is a project requirement and can not be uninstalled. But I need the MySQLdb for Python ...
0
votes
1answer
37 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
1
vote
1answer
1k views

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

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
69 views

Is it better to store the MySQL database directory on a separate RAID 1 device?

We have a Linux server with a RAID 1 using two HDDs on which runs a Apache server managing multiple sites and some other services that interact intensively with the databases and produce massive ...
4
votes
1answer
74 views
+100

MySQL package upgrades (Debian apt-get) always break master-master replication due to changes in mysql schema

I have master-master replication set up on 2 Debian servers, and they replicate everything, including the mysql database itself (so that new users and such also replicate). This generally works very ...
3
votes
2answers
84 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...
11
votes
4answers
3k views

How to reset or recover admin account password for MySQL?

I have a MySQL database that I "inherited" and I was not given the admin credentials. I do however have access to the box that it runs on. Is there a way to either recover the admin credentials or ...
2
votes
1answer
30 views

Server error with large posts

On a large drupal site, the database server is on a separate server connected directly to the web server. The web server uses apache and memcached. The problem is that whenever the post is a large, ...
1
vote
1answer
21 views

MySQL not allowing remote connections from new server

I currently have one server that's connecting to a centralized MySQL server (say, 192.168.0.10). This server already allows remote connections from this IP address (say, 192.168.0.20), and in spite of ...
0
votes
1answer
18 views

mysql and redis services unavailable during high traffic times

I've have a webserver that runs some services like Apache, Mysql, Redis and some NodeJS apps. On times of high traffic my server seems to do not support the heavy load. When it's ocurring, often when ...
1
vote
1answer
28 views

Unable to Create MySql 64-bit System DSN on windows

I have a very similar problem to this: Unable to Create System DSN but none of the fixes suggested there have worked for me. System: windows 7 64-bit enterprise. I'm trying to create a DSN to use ...
0
votes
2answers
2k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
-1
votes
0answers
16 views

Need to deploy php and java application together on openshift.redhat.com [on hold]

I have a Java and PHP Website. Front end code in PHP and Java call some library. How can i deploy php and java application together ? I have a java war file, PHP Code and One database file.
0
votes
2answers
747 views

Can't connect from EC2 to RDS via PHP. I can directly thought

I've set up an EC2 instance it has mysql and php-mysql installed (not mysql-server). I've set up an RDS instance and set the security group to the EC2 instance. I can connect via the command line ...
-3
votes
1answer
64 views

Mysql showing 100% CPU usage [on hold]

I'm experiencing some problems with my MYSQL server installed with Cpanel. My server is showing 100% usage of mysql even if I don't have too much traffic on web. I am running CentOS 6.5x64 with 80GB ...
13
votes
1answer
6k views

What is “freeable memory”?

Amazon RDS has a metric for 'freeable memory'. It appears to go up & down in a sawtooth pattern. This leads me to believe that it's memory that is being used by MySQL for caching and that when ...
0
votes
1answer
96 views

MySQL allows zero date(0000-00-00 00:00:00) after I enabled strict mode

I want to configure a MySQL db instance not to accept zero dates(0000-00-00 00:00:00) because the software running on top of it fails to run if it encounters such a field. The server is running ...
-2
votes
0answers
10 views

Could not be resolved: Name or service not known

My site is running smoothly, but when I checked my db server and saw there is high memory use by mysqld. It is all the time 69.7%. Then I checked my mysqld.log and saw lots of Could not be resolved: ...
7
votes
3answers
796 views

mysql “Too many connections” killed the network? [closed]

So I'm pretty confused here, figured I'd throw this out here and see if anyone else has any good ideas. We suffered a pretty big outage two nights ago, and I'm still searching for the root cause. I ...
1
vote
1answer
2k views

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...
6
votes
4answers
3k views

Percona-server time out on /etc/init.d/mysql start

Every time I start mysql, using /etc/init.d/mysql start or service mysql start, it always times out. * Starting MySQL (Percona Server) database server mysqld [fail] However, I ...
3
votes
1answer
37 views

Enable HugePages on Linux for multiple services/processes

On one of my Debian machines I'm running a service on a JVM and a MySQL instance. I have enable the HugePages following various online guides but I'm having a problem. Here is my configuration: ...
-1
votes
1answer
30 views

make mysql to share all cpu

I am very new to linux server .I am using centos.Sometimes my cpu gets overloaded because of the process mysqld over 100% PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND ...
4
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 ...
26
votes
4answers
124k views

How to enable MySQL logging?

I am running MySQL 5.0.45 on OS X 10.6.1 and I cannot get MySQL to log anything. I am debugging an application and need to see all queries and errors. I added to the etc/my.cnf: [mysqld] ...
0
votes
1answer
32 views

Access db with dynamic IP using windows Application C#

I want to connect a Desktop Application (C#) with a website which is hosted on BLUEHOST Server (Shared Hosting). I have to add an IP on server to allow for remotely access to mysql database. But the ...
0
votes
2answers
36 views

SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) [closed]

I've changed the password for admin user of mysql in phpmyadmin and now I can't access neither my Plesk panel and neither mysql via ssh. The error it triggers is: SQLSTATE[HY000] [1045] Access denied ...
2
votes
0answers
16 views

odbc error connecting mysql: “sql server does not exist or access denied” [migrated]

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
1
vote
1answer
2k views

Mysql - innoDb - is in the future! Current system log sequence number [closed]

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
0
votes
0answers
33 views

Vagrant and MariaDB (provision)

I'm trying to create a provision file that installs MariaDB but it keeps failing. The provision looks like this: sudo apt-get install -y software-properties-common sudo apt-key adv --recv-keys ...
0
votes
1answer
31 views

MySQL intermittently fails to come up when data directory is configured on SAN via iSCSI

I am running Ubuntu Linux 14.04.2 on a Dell R610 Server. This box is used to host the MySQL service for my applications. The MySQL data directory is mounted on DELL SAN Equallogic so this box is also ...
3
votes
2answers
2k views

Can I install phpMyAdmin on its own to access a seperate database? [closed]

I'm trying to set up access to a mysql database for a separate user. Of course that's not a problem, easily set up. Separate username and password. The problem however is with my host, with mySQL ...
0
votes
1answer
34 views

Can't connect to MySQL server on '198.211.37.xx'

For last couple of days I have tried many things to solve Can't connect to MySQL server. I would like to describe everything that I did so far. Create a mysql user and GRANT ALL Privileges. Bind ...
1
vote
3answers
60 views

MySQL connection - Access denied for user 'username'@'localhost' (using password: YES)

I have a user that I use from my php pages to make queries to mysql db, and now I´m trying to use the same user in eclipse/BIRT in order to build some reports but I get the error Access denied for ...
2
votes
4answers
121 views

MySQL Server : Most Frequent Requests

I would like to know if there is anyway I can display the most frequent SQL query on MySQL server in order to memcache it.
0
votes
1answer
942 views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...