The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [mysql]

An open-source, relational database management system.

222 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
35 views

plesk mysql reporting different version in cli to a version query

I'm trying to upgrade a Plesk server running Ubuntu (12.04.2 LTS) and when doing a query check on apt-cache: apt-cache policy mysql-server ... it reports that I have the latest 5.5. branch already ...
1
vote
0answers
410 views

Database client version mismatch in PhpMyAdmin

I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this: Database client version: libmysql - 5.5.50 But when I do this in the terminal: mysql -V I get ver. 5.5.52 Also in Synaptic Package ...
1
vote
1answer
304 views

Screwed up installing phpmyadmin and now mysql / mariadb won't start

I'm using ubuntu 14.04 and did a apt-get install phpmyadmin I went through the install process and forgot to check off an option to install it for apache2. The install didn't finish, but it must have ...
1
vote
0answers
1k views

Using yum to upgrade from MySQL 5.1.73 to 5.7.13

I've picked up an IT role and I'm new to yum so please forgive me. yum list shows these mysql packages installed: mysql.x86_64 5.1.73-5.el6_6 @base ...
1
vote
0answers
627 views

Can't MariaDB and Mysql install on the same machine?

I have to install Mysql as a metastore for the cloudera HUE. But on that machine, it seems MariaDB is on that machine. I use yum to install yum install mysql-community-server I got this error. ...
1
vote
1answer
1k views

PHP does not use MySQL default sockets

I am having a hard time understanding why PHP cannot connect with localhost as a host. I can connect by doing: mysql -uroot -p And also, through Sequel Pro I can connect with localhost as a host. ...
1
vote
1answer
505 views

SELinux, MySQL, and shared memory

On an SELinux enabled Oracle Linux 6 host, I have a product using MySQL as its underlying database and, through the database, is trying to access /dev/shm. /dev/shm mounts with context tmpfs_t, by ...
1
vote
2answers
7k views

Can't connect to local MySQL server

I want to run a website from my computer. I use XAMPP on a Kali Linux. I installed MySQL server with the command: apt-get install mysql-server After it was successfully installed, I entered the ...
1
vote
0answers
144 views

Systemd: Running a script before msyql stops on shutdown

On my Ubuntu 14 vagrant box I use this upstart script to run automysqlbackup on every vagrant halt: description "run automysqlbackup" start on stopping mysql task exec automysqlbackup So ...
1
vote
0answers
147 views

Monitoring mysql with munin - worse MySQL performance?

If I monitor my MySQL server with munin, can I envisage with worse MySQL performance? When I want to activate statics as an example in PHPMyAdmin it says that the MySQL performance can be inferior as ...
1
vote
1answer
1k views

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

I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server. mysql -u root -proot csv_imports -e "LOAD DATA INFILE '/var/www/html/$...
1
vote
1answer
157 views

Install mysql-workbench in fedora 21

I already install mysql-workbench in fedora 21 from rpm: yum localinstall mysql-workbench-community-6.3.5-1.fc21.x86_64.rpm But when I tried to launch apps by command: /usr/bin/mysql-workbench --...
1
vote
0answers
1k views

MariaDB Dependencies issue after isntall/remove

I tried to "upgrade" MySQL 5.5 to MariaDB by removing MySQL altogether. Then I installed MariaDB 10.1 as follows: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --...
1
vote
0answers
737 views

Mysql 100% 1 core CPU load

I have 8 cpu in server, and Mysql works only on 1 cpu core on 100%. How can I use all cores? my my.cnf [mysqld] safe-show-database query_cache_limit=1M query_cache_size=64M ## 32MB for every 1GB ...
1
vote
1answer
737 views

Linux Mint 17 Cinnamin + MySQL + turn OFF autostart

I have tried all the suggestions in hours of googling and still when I reboot and run service mysql status my server is running. since i only use mysql for database testing with my java apps i don't ...
1
vote
0answers
617 views

httpd and mysqld used out of memory

I choose 512mb ram for my Centos VPS with very low traffic new website .but after 2,3 hours after rebooting, i have only 24mb free memory. when i use top command: 2981 root 20 0 37176 10m ...
1
vote
1answer
469 views

Can't find job mysql on crouton, ubuntu precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: (precise)...
1
vote
0answers
38 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, because even the database couldn't save new rows. ...
1
vote
0answers
349 views

Unable to install mysql-server-5.6

My website was running fine on server version 5.5, but now it hangs on the installation of version 5.6. I've tried removing it, purging it, even removing the /etc/mysql folder, then reinstalling it ...
1
vote
0answers
1k views

mysql service exiting without error

I have installed mysql-community-server on openSUSE and am having trouble starting it as a service. I can start it using sudo mysqld --user=mysql without a problem and access the database normally. ...
1
vote
0answers
269 views

Zombie mysql process ? - linux Mint

I am having the following problem with MySQL and Mint: mysql is set to run at startup: sudo update–rc.d mysql defaults After startup the service is running and I can connect to the database through ...
1
vote
2answers
1k views

Centos 7 - Recover mysql db from data files .frm and .ibd

I have migrated my operating system from Windows to Centos 7 without getting backup of mysql through mysqldump. Now I have mysql data files .frm and .ibd . I want to migrate them How can I migrate ...
1
vote
0answers
30 views

Howdo i avoid older mysqlclient versions

i'm running some CentOS servers. PHP and MySQL are installed from 3rd party repos. My problem is that on all servers i always have php mysql clients running their version far behind the actual mysql ...
1
vote
0answers
58 views

After rebooting server, service start without special chars

I wrote a simple Java server. This service (java server) connects with a mySQL database. I am connecting to this service with a socket connection. Everything works well when I start my service by ...
1
vote
1answer
607 views

Unable to access another server over local network on Digital Ocean

I have two servers. Let's call them A and B. Both are running ubuntu server 14.04. B runs percona server. Now I do not have any firewall set-up on either servers still I am unable to connect to server ...
1
vote
0answers
4k views

Error starting MySQL in a MariaDB Galera cluster in CentOS 7

I'm trying to setup a MariaDB Galera cluster following this tutorial exactly as it is, and I'm stuck in the Step 7– Initialize the first cluster node, I'm doing so with sudo /etc/init.d/mysql start --...
1
vote
1answer
197 views

Rebooting Centos Servers configured with MYSQL Master/Slave Replication

Sometime ago we configured MYSQL replication on our main web server to another CentOS 6 server. All is working perfectly and we can see the replication is working fine. My question is how to safely ...
1
vote
0answers
24 views

Finding out the script causing MySQL failed connections

I see lot of lines in mysql.log Connect Access denied for user 'M'@'localhost' (using password: NO) I am sure I don't have such a user on my system. I need to figure out what script is ...
1
vote
2answers
3k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld....
1
vote
0answers
623 views

I Need Find A Mac Address from a client connected to my Teamspeak

I have a dedicated server and from it I am running a teamspeak 3 server. In teamspeak server there is a client who need to be banned. I have banned him from teamspeak but if you change your windows ...
1
vote
2answers
401 views

Running SQL call as root user in init.d script?

I have an SQL query that must be run on every startup after a software update (updates come with new installations of mysql and thus change the debian-sys-maint user's password, which my script ...
1
vote
1answer
790 views

Cacti/rrdtool error -> Poller[0] ERROR: SQL Row Failed!, Error:'1033'

I have cacti working flawlessly on a centos 7.0 machine but I need it working on a centos 6.3 machine. I download the same version of cacti as what is on the 7.0 and I installed rrdtool from yum. ...
1
vote
0answers
158 views

How to debug the network issue in case of blocked database connections

I am trying to understand if my analysis of the below information is correct. For all the 3 scenarios listed here, port 80, port 3306 and port 22 are open in the server's firewall. Also, for all the 3 ...
1
vote
1answer
267 views

How to set up Cron to run mysqlauditgrep command for 11AM on Friday

I am trying to set up cron to run the mysqlauditgrep command (its the MySQL 5.6 Utilities package). The mysqlauditgrep command is in bash. The command I am looking to run is: mysqlauditgrep --format=...
1
vote
0answers
116 views

Ubuntu with LAMP+Mediawiki suffering spikes

I'm sorry if this question is off topic, but I'll give it a shot: I have a VPS running Ubuntu 12.04, a LAMP stack, and Mediawiki. After installing Mediawiki I noticed that my wiki site was spiking, i....
1
vote
0answers
7k views

mysqld dead but pid file exists

Webserver was running fine for weeks then suddenly: I can access, but I am unable to log into Webmin I can access Magento, a php-based storefront application, but I am no longer able to log in and it ...
1
vote
1answer
314 views

php-mysql not working

I'm running on RHEL6. I have installed php and php-mysql. <?php phpinfo(); ?> is working perfectly. But I can't connect to MySQL is there a way to confirm that php-mysql is not working on my ...
1
vote
1answer
2k views

Creating MySQL database and user without password

I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: ...
1
vote
1answer
820 views

Installing multiple versions of MySQL on Oracle Linux

I have a Oracle Linux 5 server. I have to install MySQL 5.1 as well as MySQL 5.6. Is it possible to install both version of MySQL on the same machine? If yes, how can I achieve this?
1
vote
0answers
78 views

Mysql user privileges : Only CREATE table

I am trying to create a user who will be able to manage all databases without the right to CREATE and DROP databases. I have been using the following link : http://dev.mysql.com/doc/refman/5.0/en/...
1
vote
1answer
255 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it fails and the ...
1
vote
0answers
1k views

Amazon EC2 MySQL Failed to Start

I'm having issues starting MySQL after it randomly stopped working a few minutes ago. I'm getting this error while trying to connect: Connect failed: Can't connect to local MySQL server through ...
1
vote
0answers
421 views

Force mysqldump encoding

I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same : $ mysql -h right_server -NBe "SHOW ...
1
vote
0answers
2k views

Fedora Failed to get D-Bus connection

I have a VPS with fedora 16 installed. I have setup mysql and it was working a couple of days ago. Now suddenly when I try to start mysql I get the error: Failed to get D-Bus connection: Failed to ...
1
vote
0answers
925 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
1
vote
1answer
2k views

Linux ports are blocked even when firewalld is disabled!

RHEL 7.4 I disabled the firewalld and also checked that SELINUX is disabled. But still when I use telnet to check the ports, port 3307 refused the connection. Even port 80 rejects the connection. ...
1
vote
1answer
1k views

how to restore a mysql database from full database backup

I have all MySQL databases backup dump file (50 Databases) with in a server, and i want to restore a single database from this dump file.Is that possible? Any suggestions? Thanks in Advance
1
vote
1answer
148 views

Bash script to install website

First of all, excuse me if this is the wrong place to ask this question. I made a Bash script which installs a DirectAdmin backup into Apache. The steps are working but in the end I get a 500 error ...
1
vote
2answers
1k views

How can I make apache to start up automatically on linux mint?

I have installed Linux Mint 18.1 Serena and I have XAMPP 5.6.28-1 on my computer. After I turn on my computer, I must run the XAMPP control panel and I must start Apache and MySQL manually. Does ...
1
vote
3answers
718 views

yum ignoring exclude directive in yum.conf

I need to hold back mysql from being updated in yum update. I added exclude=mysql* to /etc/yum.conf as below: [main] cachedir=/var/cache/yum/$basearch/$releasever keepcache=0 debuglevel=2 logfile=/...