An open-source, relational database management system.
1
vote
1answer
19 views
Start Mysql/Mariadb in Fedora failed
failed to start mysql in Fedora 17. I am using root account to run the below commands and selinux is disabled.
service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for ...
0
votes
1answer
22 views
Mysql Database files read access
Right now I'm trying to set read access to the files of one of my databases. I'm using debian with basic mysql installation so the database location is /var/lib/mysql.
I want ...
0
votes
1answer
30 views
Disable MySQL startup arch
I have KDE, and it has software to manage startup packages. But, I don't see any mysql, mariaDB or mysqld service.
How can I disable or prevent the mariaDB and mysql daemons from starting ...
1
vote
2answers
44 views
Ubuntu: where add a script executing SQL on machine start?
Each time Ubuntu is starting I need to run a script, which is running some SQLs.
So I need run it after MySQL already started.
Where should I put such script?
0
votes
0answers
80 views
MySQL max_open_files more than 1024
While starting MariaDB I got [Warning] Could not increase number of max_open_files to more than 1024 (request: 4607)
$ sudo systemctl status mysqld
● mysqld.service - MariaDB database server
...
1
vote
1answer
138 views
Problems installing mysql on debian
I have a :
user@Node:~$ uname -a
Linux Node 2.6.32-042stab092.1 #1 SMP Tue Jun 24 09:10:28 MSK 2014 x86_64 GNU/Linux
With a :
user@Node:~$ cat /etc/debian_version
7.6
and I am having problems ...
2
votes
2answers
73 views
MySQL different database location [duplicate]
I do not have enough space on my root partition to store the database.
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/ManjaroVG-ManjaroRoot 29G 21G 6.4G ...
0
votes
0answers
22 views
How to get ids from xml file into mysql?
I've got 8 xml files and need to do some work on these records in mysql. What is a good way to get these IDs into mysql?
<?xml version="1.0" encoding="utf-8"?>
<Records>
<Record>
...
0
votes
1answer
30 views
Execute MySQL commands directly instead of entering console first
PostgreSQL
In PostgreSQL it is possible to execute commands without entering the postgres=# console by executing sudo -u postgres psql -c "\l" instead of entering the console first and executing \l. ...
0
votes
2answers
58 views
Editing /etc/init.d/mysql to remove mysql.sock automatically
I am running MySQL on a CentOS release 6.5 (Final) virtual machine. It is used for testing Joomla.
The phyiscal host reboots frequently, which is fine. The VM, however, does not perform a clean ...
0
votes
0answers
40 views
Updating data sets from Online databases/Webservice
I want to have an idea as to how to update the data regularly from the source, if its stored locally in your server or local machine.Lets say MySQL database.
Source:It will be a webservice data ...
0
votes
1answer
43 views
Moving from InnoDB to TokuDB
I'm running MariaDB 10.0.x and I would like to move from InnoDB to TokuDB.
When using ALTER TABLE <> ENGINE=TokuDB; everything goes fine for the Wordpress websites. Unfortunately the Magento ...
0
votes
1answer
42 views
Other Programs Cannot Connect To MySQL
So just recently when installing php-fpm, I had installed a few MySQL packages with it (I believe). I already had mysql installed. However now when any of my programs attempt to access the database, ...
2
votes
0answers
204 views
How do I install postfix with MariaDB 10.1? …Or mailserver…?
I'm using CentOS 7 x64. Log: There isn't mariadb-libs for 10.1, not that I'm aware of. There is MariaDB-compat which as I found out seems to provide the same functionality and I have it installed, but ...
0
votes
2answers
201 views
Can't start mysql service
Trying to start my mysql service.
/etc/init.d/mysql start
returns:
Job failed. See system logs and 'systemctl status' for details.
Further:
systemctl status mysql.service
returns:
...
0
votes
0answers
29 views
Installing MySQL 5.6 Validate password plugin
So I have installed MySQL 5.6.19 Enterprise Edition and have installed the validate_password.so plugin. My question I have is, Does the MySQL password policy notify the user of what the requirements ...
1
vote
0answers
29 views
Unable to install Mysql
When I install mysql on my Centos, I get the following error:
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist ...
0
votes
1answer
51 views
Unable to install yum and mysql,ssh
When I go to install mysql on CentOS 6,I get the following error:
yum install mysql mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
...
0
votes
0answers
234 views
Running MySQL in a Docker container
So my ultimate end goal is to run a MySQL Docker container (say tutum/mysql from the public registry) and then link a Gitlab Docker container (say sameersbn/gitlab) to it, where both containers use ...
0
votes
1answer
24 views
Immediately kill MySQL
I have a shared server that someone has compromised Wordpress. Is there an easy way to kill MySQL. I am stopping the service but it is just sitting and waiting.... to stop
Shutting down MySQL ...
3
votes
1answer
83 views
How do I parse a string in bash into variables using a tab as the delimiter and preserve spaces?
I am in the process of writing a bash script to display various statistics, some of which come from a MySQL database. The pertinant code I'm having difficulty with is:
read min max rows <<< ...
0
votes
1answer
173 views
Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)
I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output:
While not mandatory, it is highly ...
2
votes
1answer
56 views
mysql fail to start bash_completion errors
So after upgrading my debian system, mysql does not start anymore with command "service mysql start". I get:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' ...
0
votes
0answers
47 views
Why does “Connection Failed: 2002” display randomly on my PHP/MySQL website?
I'm running CentOS 6 with Apache/PHP/MySQL. PS. I'm sort of a novice at Linux, but I did my best to gather info before coming here. I'm now a bit stuck.
I recently upgraded PHP to version 5.5.12.
I ...
-1
votes
1answer
85 views
MYSQL : Connecting to mysql from : 127.0.0.1 + telling ip tables to allow only 127.0.0.1 for mysql port : Logic vs Common Sense
If i make 1 billion or 1 trillion queries to MYSQL database from 127.0.0.1 via port 3306.
vs
If i make same amount of queries to MYSQL database also from 127.0.0.1 via
port 3306.
but with ...
2
votes
1answer
191 views
Can't use my old my.cnf from MySQL 5.5.38 in newer 5.6.19
Ok so I have been trying to upgrade MySQL 5.5 to 5.6. I have been given this set my.cnf file (see below). I was able to uninstall the MySQL 5.5 rpms and install the 5.6. When I reload the back up ...
0
votes
0answers
20 views
In Ubuntu, what is the folder in which MySQL's UDF should be installed?
I am using Ubuntu 14.04. I wonder where should I install binary UDF for MySQL. Is there any way to discover the path of the UDF directory? Is there a standard for this in Ubuntu?
1
vote
0answers
41 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 ...
0
votes
3answers
65 views
How do you view a sql.gz file as plain text SQL from the command line?
How do you view a sql.gz file as plain text SQL from the command line?
I want to read the SQL statements stored in a .sql.gz file, from the command line on the server. I've tried tar -xzvf, but get ...
0
votes
1answer
47 views
mysql jdbc connection issues in RHEL 6
I have setup the mysql database in one of the RHEL 6 servers. I would like to connect to this server's database from any other machine using a java program. How should I do it?
0
votes
0answers
25 views
Mysql Cluster Data node not started
I am working on Mysql Cluster in Fedora. I have three Fedora virtual machine. One is Management node and other two are Data node.
My Management node started but my Data nodes are not started.
When ...
1
vote
0answers
820 views
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [closed]
When I try to start MySQL it says "failed!", so I try using mysqladmin ping and get the following:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server ...
4
votes
1answer
199 views
I get the Error “mysqld dead but pid file exists”
I get the Error mysqld dead but pid file exists
This happens every couple of hours. If I restart it works fine and then goes down again.
[root@ip-10-0-0-149 log]# df -h
Filesystem Size Used Avail ...
3
votes
2answers
61 views
How to make Cron run
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 ...
1
vote
1answer
57 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 ...
0
votes
0answers
29 views
MySQL Failing Randomly
I have a problem with my MySQL database.
consider this scenario:
[/] remorseful:root> mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
...
1
vote
0answers
12 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, ...
2
votes
1answer
63 views
mysql restoration process takes longer time
I have a Ubuntu 8.04 machine which has around 300 GB size mysql databases. I have dumped all the databases using the mysqldump command as below.
mysqldump -u root -p --all-databases > file.sql
...
0
votes
1answer
53 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 is not allowed access from public network.
How to write the iptables rules DNAT 53306 to 127.0.0.1 3306?
2
votes
2answers
708 views
Cannot install mysql-server-5.5/the following packages have unmet dependicies
I'm using ubuntu 14.04.
I tried entering mysql with the following command:
mysql -u root -p
and I got the following message:
The program mysql can be found on the following packages:
...
0
votes
1answer
79 views
installing php-mysql on rhel6
I have rhel6 running on my server and installed mysql from Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle. Now I want to host a php site on that machine. And when I run yum ...
0
votes
1answer
53 views
How to reconfigure PHP
We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I am a beginner on linux. Actually, I don't know how to install software on ...
2
votes
1answer
109 views
Mysql synonym drop and create
I am running into the issue that, when the script is run, the MySql section of it isn't working or is droping the synonym. Is there something else i need to put into the command to have it log into ...
1
vote
0answers
29 views
MySQL: Tab-completion not working [closed]
Tab completion in mysql is not working. I tried to start mysql with
mysql --auto-rehash
but it didn't work either. I also tried
mysql> \#
but autocompletion refuses to complete my commands. ...
0
votes
0answers
28 views
MySQL is running out of cache
I installed MySQL Workbench on Linux Mint 17. When I enter the i character from keyboard MySQL runs out cache in MySQL query display. Then MySQL shuts down. I would appreciate it if you could help.
0
votes
0answers
389 views
phpmyadmin doesn't work after installing php5-mysqlnd
I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked.
Then later after some developing on some pages I noticed I couldn't execute ...
1
vote
1answer
43 views
Mysqld_multi doesn't recognize groups
I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is ...
1
vote
3answers
61 views
mysql database no space available
I was restoring a 200 GB database into a newly installed RHEL machine. However, while restoring I ran into no space available issue.
Is it possible to change the directory where the databases are ...
1
vote
2answers
75 views
how to insert many similar records in mysql at a time?
we know that we can insert multiple records at a time using this query:
INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'),
('name2','surname2'),
('name3','surname3'),
...
0
votes
1answer
80 views
Rooting Linux via mysql
I have a CentOS 5.6 x86 installed. I have full access to mysql but it seems I have forgotten Linux root password. How I can access the root via MySQL? Is it even possible?
Update: MySQL Version is ...
