MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
2answers
272 views

can't install mysql-devel on centos 6.5

I need mysql-devel package to be installed on my CentOS 6.5 running Percona 5.5 (already installed & running). When I try to install the devel package like this: yum --enablerepo=remi install ...
1
vote
0answers
38 views

phpmyadmin not working after mysql update

i followed this guide to update my mysql form 5.1 to 5.5. After lots and lots of command and headache, i was able to upgrade mysql. i checked the version via terminal. But now there is another ...
0
votes
0answers
44 views

Token Mismatch When Accessing RDS Instance Through phpMyAdmin on localhost

Having problems using phpMyAdmin with a RDS instance. This is the guide that I used. phpMyAdmin is installed on my Windows 7 laptop and I can connect to the RDS instance and I can see the databases ...
0
votes
1answer
85 views

Xubuntu Desktop 14.04 - service mysql start unknown job

I installed fresh XUbuntu desktop 14.04 (as a dev system) and then lamp server using sudo apt-get install lamp-server^. I can type mysql and mysql console run but if I try service mysql start I got: ...
3
votes
1answer
89 views

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, ...
-2
votes
2answers
381 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [closed]

root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
1
vote
1answer
41 views

Locked out of my own MySQL Database [duplicate]

I logged into my SQL server today using PhpMyAdmin, and it seems to be acting weird throwing random [Token Mismatch] errors, only while trying to create a new user account. I tried multiple times, ...
0
votes
1answer
43 views

Installing mysql using rpm in linux through commandline

I'm trying to install latest version of mysql server. I tried to uninstall mysql 4.1 using rpm -e . Once uninstallation done I tried to download mysql packages: Command : wget ...
1
vote
1answer
16 views

Clean ndb_binlog_index file

I have a question about one of my ndb clusters. because there are two files too big and I don't know why... ls -la -rw-rw---- 1 mysql mysql 32827950588 May 25 12:35 ndb_binlog_index.MYD -rw-rw---- 1 ...
1
vote
0answers
19 views

Concurent access on a replicated table in mysql [closed]

I have 2 servers with MySQL master-master replication set. I also have 2 identical bash scripts connecting every 100ms to the DB to fetch a new record with Status=0. Upon fetching a new row the ...
0
votes
1answer
30 views

uninstall mysql in linux server giving error

I'm trying to uninstall mysql 4.1 package in linux server. Command : yum remove mysql mysql-server It is giving error : Setting up Remove Process Resolving Dependencies --> Populating ...
1
vote
0answers
68 views

PhpMyAdmin Hangs On MySQL Error

I'm currently running PhpMyAdmin 4.0.10 (the latest version supporting PHP 4.2.X) on my Amazon EC2 connecting to a MySQL database on RDS. Everything works perfectly fine except actions that return a ...
-2
votes
2answers
93 views

After Importing 60 000 products data My magento Website become Too slow to load [closed]

Site was working well when I had around 20k of products in MySQL database. Later I have uploaded/imported more data from csv file, I have imported around 60,000 total products. But Now onward, I'm not ...
0
votes
0answers
94 views

MySQL Workbench Could not connect to Source DBMS

I have a server which has a MSSQL database and i trying to data migrate from MSSQL to MySQL, in the first stop after i choose database --> data migrate --> i choose data system (Microsoft SQL server) ...
0
votes
1answer
63 views

Got more ram, site slower [closed]

I was running my site on 256MB of ram with 2 cores and it was running ok, but I decided to upgrade to 1GB and 4 cores but now my site is slow.. I mean it takes more then 22 seconds to load 1 page.... ...
1
vote
1answer
51 views

Storing Postfix's passwords in MySQL without encryption

I've been struggling with Postfix for past few days. Finally I managed to set it up with virtual mailboxes listed in MySQL and passwords encrypted with PAM. It was just then that I realized I need the ...
1
vote
0answers
20 views

PHP-FPM slowlog and Mysql lost connection

I was having an issue with PHP-FPM and mysql. When I needed to process an input file that would generate several selects/inserts/updates for each line, it would stop after approximately 60s with ...
0
votes
0answers
75 views

Postfix + Dovecot + MySQL : (user unknown) on virtual users

I've set up a mail server using Postfix + Dovecot (dovecot auth) + Postfixadmin The server is working great, be it for SMTP or IMAP, except that messages to virtual users get bump with the following ...
0
votes
0answers
54 views

authenticating and authorizing linux users kept in mysql database using pam and nss

I am not able to authenticate and authorize users present in my mysql database. If someone can point out where I am wrong it would be very helpful.Following are the steps that I followed. Firstly I ...
1
vote
2answers
176 views

Mysql: GRANT command denied to user 'root'@'dhcp-x-x-x-x.<company>' for table 'testtable'

I am new to MySQL admin duties, and am trying to unsuccessfully grant SELECT Permissions to a limited number of columns in a table, using MySQL Workbench 5.2.44: GRANT SELECT (col1, col2, col3) ON ...
1
vote
1answer
70 views

ERROR 1044 (42000): Access denied for 'root' With All Privileges when root user is missing in plesk installation

My provider has supplied a Ubuntu 12.04 LTS LAMP installation with a bunch of software preinstalled. The system is supposed to be mantained using Parallels Plesk (which I unfortunately didn't know ...
1
vote
2answers
31 views

EFS on MySql Data Folder Prevents MySql Service from Starting

I'm trying to encrypt my MySql database at rest. I have been looking at Truecrypt and EFS - I ultimately went with EFS because I can simply encrypt an existing folder without having to create a ...
1
vote
2answers
124 views

FreeBSD default MySQL basedir, port, etc., for my.cnf

I'm working on a FreeBSD 9.2 server and have run mysqltuner.pl to check the memory and cache needs of MySQL. Now I need to add a my.cnf file to FreeBSD so it uses that instead of the auto cnf file. I ...
1
vote
2answers
96 views

Server 2012 Scheduled Task CMD mysqldump not doing what is intended

I'm running a batch file to back up some mysql databases on a 2012 webserver. The batch file creates a folder, then runs the following for each db: mysqldump -u *username* -p*Password* *db_name* ...
1
vote
0answers
45 views

Rackspace Cloud Server / DB - getaddrinfo failed

I recently migrated my MySQL instance from my debian server to a cloud database server at rackspace. A couple times of day since then, I notice in the log files that we have the following error: PHP ...
1
vote
1answer
111 views

Error when i install mysql + galera

I want install mysql server + galera in my vps Centos 6.5. When I install yum update -y && yum install wget libevent perl mysql-y wget ...
-1
votes
1answer
58 views

RHEL 6.5 / Updating MySQL [closed]

Currently running RHEL 6.5 and need to update to MySQL 5.5.36. Currently it has MySQL 5.1.73 installed. The Software Collections repo has been added. I performed a yum update and it does not show me ...
3
votes
2answers
74 views

/etc/mysql permissions don't let non superuser connect to socket

We're running Ubuntu server 13.10 under Vagrant, and have come across an interesting problem. We're overriding the socket location in conf.d/my.cnf [client] port = 3306 ...
1
vote
0answers
31 views

What can be done to prevent “failed to flush master info” in MySQL replication?

I have two MySQL 5.1 servers setup with master/slave replication. I was previously using 5.1.41 for several years without issue. However, since I've upgraded to 5.1.72 (and did some other tweaks ...
1
vote
1answer
42 views

How to import MySQL dump which is encoded with quoted printable?

I got a MySQL DDL file ddl.sql which I would like to import. It starts like this: --=20MySQL=20dump=2010.11=0A--=0A--=20Host:=20localhost=20=20=20=20= Database:=20ww=0A--=20= ...
0
votes
0answers
69 views

mysqlnd doesn't seem to be with php 5.4

i went to update my website the other day on hostmonster but despite it working perfectly on development it had the error. Fatal error: Call to undefined method mysqli_stmt::get_result() ...
0
votes
0answers
58 views

my.cnf doesn't work in my server

now i am using percona server 5.6 on CentOS 6.5. I wanna change query cache setting. I tried to change setting /etc/my.cnf. but it didn't applied. To investigate whether my.cnf is read correctly,all ...
-1
votes
1answer
123 views

How I can optimise my MySQL installation? [closed]

(Debian 7 32-bits KVM with 512mb RAM - SSD storage - 1 cpu) The server is not mysql dedicated. It runs a small forum on it. (Mysql -> read-mostly) Does anyone have any advice as to how I can ...
-1
votes
1answer
58 views

what is the purpose of support files in MySQL?

I have installed MySQL 5.6.17 on my Ubuntu 14.04 following the instructions at http://dev.mysql.com/doc/refman/5.0/en/binary-installation.html. The instructions says to use the optional command : ...
1
vote
2answers
46 views

Dovecot unable to perform mysql query

I have been following the ISPMail tutorials on workaround.org (the 2.9 Wheezy version) and thus far everything has been working fine. When I reached the step to "Testing email delivery" step I noticed ...
0
votes
0answers
177 views

Dovecot Postfix SMTP-AUTH dovecot: imap-login: Disconnected (auth failed

I am installing a new mail server using postfix dovecot , mysql and roundcube 0.9.5 as mail client with the smtp-auth functionality and below are my configurations.I am failing to authenticate and ...
1
vote
0answers
55 views

Enable FEDERATED ENGINE error

I need to enable FEDERATED ENGINE on Mysql (version 5.5.35). I set in /etc/my.cnf file line federated. Restart my mysql server, then check in mysql using command SHOW ENGINES, and result is: ...
0
votes
0answers
32 views

How to setup Postfix with MySQL while each user has its own maildir path?

I'm trying to make Postfix use MySQL as its virtual configuration storage. I've been reading this article. In there user table comes without a maildir path field. But I need Postfix to store incoming ...
0
votes
2answers
67 views

RADIUS-sever: Hashing password before checking

I do have to set up a RADIUS server for authentication with a captive portal of pfSense. Unfortunately, all passwords in the RADIUS' database are hashed with a certain algorithm. I do use a ...
0
votes
0answers
52 views

high mysqld cpu usage after moving to new server

Just moved to a new (more powerful) server with only one website running on it, no changes on the website, but now I got a horrible high CPU load and I can't find out why. top: top - 22:54:08 up 1 ...
1
vote
1answer
215 views

How to install MySQL 5.1 libraries on Ubuntu 14.04 or CentOS?

I've got two VMs: CentOS 6.5 and Ubuntu Server 14.04. Neither of their package management systems has the MySQL 5.1 libraries available (they both have MySQL 5.5). I need to know how to install the ...
0
votes
1answer
81 views

FreeRADIUS w/ MySQL backend. IP Pool

I have a pool of addresses (172.16.0.0/24) configured on my NAS (Cisco 2921 router) for my IPsec clients. I have various subnet mask length subnetworks used for different user groups. For example I ...
-3
votes
1answer
31 views

How to solve this odd error in mysql? [closed]

I upgraded mysql 5.5 to 5.6 in directadmin and now http://p30rank.ir/phpmyadmin/ has error #2002 - No such file or directory The server is not responding (or the local server's socket is not ...
-3
votes
1answer
58 views

Improve LAMP performance Ubuntu 12.0.4 [closed]

cpu 1.3% mem 476/490MB swap 347/511mb tasks: 43, 29 thr; 1 running load average: 0.10 0.08 0.06 via htop:<br> /usr/sbin/apache2 -k start (listed 8x @ 8.1% mem each) /usr/sbin/mysqld (listed ...
-1
votes
1answer
26 views

MySql table size increase

We have old Bugzilla installed 2.20 install Debian Sarge 32bit with MySQL 4.0 Server running fine. Unfortunately from Yesterday noon, It started through error stating below. DBD::mysql::st execute ...
0
votes
1answer
90 views

mysql 5.6 doesn't start automatically on redhat 6.4 server start-up but do start when manually run “service mysql start”

I'm trying without success to set mysql to start automatically (mysql 5.6 on RHEL6.4) When I run "service --status-all" after server (redhat) restart it always shows "MySQL is not running, but lock ...
4
votes
2answers
276 views

How to pass input from one script into another using bash

I am writing a script where I am want to launch the mysql_secure_installation script and provide the appropriate answers at each prompt. I tried using echo like this: echo -e ...
1
vote
1answer
55 views

Incomplete parameters passed from Postfix to Dovecot during AUTH PLAIN transaction

I'm migrating from an old CentOS box to a new Ubuntu server. I have a working Postfix/Dovecot/PostfixAdmin/SpamAssassin/Clamav system working on CentOS, and am trying to simply replicate the same ...
0
votes
1answer
47 views

yum update MemoryError 1G memory free

I am trying to do yum update and getting "MemoryError". The server (OpenVZ box) has 2G RAM and Percona MySQL server running with 1G InnoDB buffer configured. The OS is CentOS 6.5, kernel ...
0
votes
1answer
119 views

Mysql crashed and won't start up

Our production mysql server just crashed and won't come back up. It's giving a segfault error. I tried a reboot, and just don't know what else to try. Here is the stacktrace: 140502 14:13:05 [Note] ...