The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
597 views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
2
votes
1answer
558 views

MySQL 5.5 on CentOS 6 — mysql user 'root@localhost' cannot grant privs

This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and . I know the password is correct as I can log in with root@localhost to the mysql server and can also create ...
1
vote
1answer
36 views

WinServer 2008 R2 MySQL cluster service won't start

So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage). When the cluster ...
1
vote
1answer
25 views

Linux iptables DNAT 53306 to 127.0.0.1 3306

mysql real port is 3306。 I want public network using 53306 to visit mysql,and 3306 not allowed access from public network. How to write the iptables rules DNAT 53306 to 127.0.0.1 3306 ? help me
1
vote
1answer
2k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
1
vote
1answer
83 views

mysql slow queries not writing to log

I have the following slow query information setup in mysql. SHOW VARIABLES LIKE '%SLOW%'; Variable_name Value log_slow_queries ON slow_launch_time 2 slow_query_log ON slow_query_log_file ...
1
vote
1answer
307 views

MySQL is too slow on Windows VPS

I'm running a wordpress blog on my VPS, But MySQL Queries are taking too much time. For example, it is taking more than 1.5 seconds to load a post from database. But CPU and RAM usage is low on my ...
0
votes
1answer
15 views

Mysql Insert query not working in php scripts - permission issue?

Problem Description I cannot write to a Mysql table using php. Native command line using mysql client works. But I can make "select" in all variants - seems like a permission problem, but what kind? ...
0
votes
1answer
270 views

mysql load_file() function always return null for symbolic link

i have installed new database server on ubuntu mysql version is 5.5.35 im trying to execute select load_file('/usr/home/aaa.com/medya_data/ver.txt') and im sure ver.txt file is exist but ...
0
votes
1answer
103 views

Queries going to mysql server even when no one is connected to it

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
0
votes
1answer
54 views

How to secure mysql server

I have an mysql client with a fixed IP that should be able to access a mysql server. The mysql client is integrated in a software and only port, ip, username and password are modifiable. What would ...
0
votes
1answer
84 views

How to solve mysql server 5.5 update dependency issue?

since a month or two i cannot update package on my ubuntu server. The problem concern the mysql package which seems newer on the server that the minimum required ?? : lm@s8:~# sudo apt-get upgrade ...
0
votes
1answer
220 views

MySQL causes iowait's since 5.5 - optimal my.cnf wanted

I upgraded my MySQL server from 5.1 to 5.5 on CentOS (with 2 cores and 2GB RAM). With my old my.cnf the mysql service doesn't start anymore (complains about a PID file), so I use an almost empty ...
0
votes
1answer
131 views

MySQL-server-5.5.18 - Installation issues / doubts

1 ) How to relocate the data dir while installing the MySQL-server-5.5.18-1.linux2.6.i386.rpm. rpm -ivh MySQL-server-5.5.18-1.linux2.6.i386.rpm
0
votes
1answer
133 views

Can't run Apache - Would having Ruby on Rails and mysql server installed on the same machine be the reason why?

everyone. I am trying unsuccessfully to run Apache on my machine. I used the command line to find out all the applications that are using port 80 and I ended them, but Apache refuses to run on my ...
-2
votes
1answer
956 views

Plesk 11.5 installation Problems on Ubuntu 12.04 unable to access mysql server

Im not able to install Plesk 11.5 on my dedicated Server under Ubuntu 12.04 LTS because the their is no access to mysql. Installtion log says: Trying to establish test connection... ERROR 1045 ...
-3
votes
1answer
2k views

High Cpu Usage after MySQL Update (5.1 to 5.5) on CentOS 5.8 (64 Bit)

General Problem: Server load 20.92 (8 CPUs) [it varies from 7 to 40, normally it should be less than 1) Server Specs: Dedicated Server Intel Core i7 (8 Cpus) RAM: 8GB We use WHM and we have about ...
1
vote
0answers
139 views

New Windows Server 2008 R2 WIMP running slower than Windows Server 2003

We recently upgraded a WIMP server from Windows Server 2003 (32 bit) to Windows Server 2008 R2 (64 bit). The new server has significantly better hardware than the old server, yet many processes take ...
1
vote
0answers
95 views

How can I set the original PHP mysql api driver to auto-reconnect by default in MySQL version > 5.0.13?

MySQL server turned off auto-reconnect by default in version 5.0.13: http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html In MySQL 5.0, auto-reconnect was enabled by default until MySQL 5.0.3, ...
0
votes
0answers
32 views

mysql -q strange behavior

Using Mysql 5.5.37-0ubuntu0.14.04.1. Doing mysql mydb works fine, but using $ mysql -q mydb shows a strange behavior when doing mysql> describe sometable; then a very large number of --- are ...
0
votes
0answers
142 views

SQL Error 1406 Data too long for column 'concatenado' mysql mac osx

I have a function column with name concatenado that is adding each titulo size 50 words each, until my subtitulo is null initially this has varchar(5000) and it is working good in Windows 8 without ...
0
votes
0answers
38 views

Mysql large memory consumption

I have a server running under openvz. System is Debian 6.0, MySql server 5.5.31 installed from dotdeb.org repo. I have very strange problem. Mysql server settings not allow Mysql to get more than 1.7 ...
0
votes
0answers
10 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
0answers
95 views

Upgrading MySQL 5.5.20 to 5.6 Identifying Weak Passwords?

I am trying to upgrade a WAMP server from MySQL 5.5.20 (32-bit) to 5.6.12 (64-bit) and when I went through the process of trying to upgrade the actual database the upgrade failed seemingly because of ...
0
votes
0answers
53 views

server pid removed after config cnf

i want config my server with this configuration : [mysql] # CLIENT # port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL # user ...
0
votes
0answers
27 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
0
votes
0answers
17 views

MySQL usage statistics by connecting user or by table

Is there a way to get some MySQL usage statistics, like aggregated number of SELECT/INSERT/UPDATE/DELETE queries, on a per connecting user or per database table?
0
votes
0answers
152 views

fail to upgrade from mysql5.1 to mysql5.5 (Ubuntu 11.04)

I follow instruction in that blog upgrade from mysql5.1 to mysql5.5: http://ronaldbradford.com/blog/upgrading-to-mysql-5-5-on-ubuntu-10-04-lts-2013-01-22/ Step 1. Remove existing MySQL 5.1 retaining ...
0
votes
0answers
146 views

Import large InnoDB table dump

i've a mysqldump ( 1.5G large ) of a table I need to import. The server i bought, which is clean and not under load, takes > 2hours to import it. I read many tweaks i can use to speed up the import ...
0
votes
0answers
475 views

Ubuntu 12.04 64bit - What would cause high System CPU %sys during high MySQL loads?

128GB RAM, 32cores Xeon RAID 10 SSD. Mysql version is the latest 5.5 for Ubuntu 12.04 . We have a lot of queries - about 1800+ per second. During high MySQL load - 2700+% load on a 32 CPU system - ...