An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
2answers
85 views

MySQL Daemon failed to start on centos

I installed MySQL 5.7 in my CentOS and tried to start the service but that gives this error. MySQL Daemon failed to start. Starting mysqld: [FAILED] mysqld....
1
vote
2answers
148 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 ...
4
votes
1answer
227 views

How do you give a developer group access to apache, MySQL, php and the webroot?

We have 3 web designers that are currently logging in to our server via root to configure apache and setup websites. I have very basic linux knowledge (I'm a web designer) and have created users and ...
5
votes
1answer
4k views

MySQL stop/waiting issues; “can't connect … through socket” [duplicate]

So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
4
votes
2answers
13k views

PHP on centos 6 not working

I have installed PHP, MySQL, Apache on CentOS 6, now I have restarted the Apache and mysql, to test PHP I have created a index.php on /var/www/html/test/ now once I go to localhost/test/index.php then ...
4
votes
1answer
159 views

If I'm logged in as root, how do I restart mysql or apache with options?

I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work! CENTOS 6, MySQL 5.14 service mysql restart service httpd restart Then I tried this: /etc/init.d/...
0
votes
3answers
28 views

Does it matter if I'm root or not when installing apache?

I need to install a LAMP stack on a RHEL 6.7 server. Do I have to be root to install this or not?
0
votes
0answers
22 views

LAMP server Installation - httpd, mysql are 'unrecognized services'

I recently installed Bitnami LAMP server to have apache, mysql and php on my server with redhat 6.7. The installation was fine, I can see httpd and mysql processes; even the wget from localhost ...
1
vote
0answers
151 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
65 views

apparmor: mysql permissions--with no recent changes

UPDATE: I now know my issue was database corruption, but discerning it was somewhat tricky--apparmor appeared to be the cause for longer than it should've. I didn't note when first posting that even ...
3
votes
1answer
63 views

Automating Master/Master replication setup and configuration on two servers

I'm in the middle of writing a script to automate configuring MySQL replication between two servers (Master/Master replication), and was looking for some advice on a few things related to MySQL. The ...
0
votes
2answers
63 views

Is the difference between mono-runtime and mono-complete related to whether MySQL inserts successfully take place on Ubuntu 16.04?

What is the difference between 1. sudo apt-get install mono-runtime and 2. sudo apt-get purge --remove mono-complete followed by sudo apt-get install mono-complete on an Ubuntu linux 16.04 instance? ...
1
vote
1answer
49 views

mysql server failed to start

I'm trying to connect to mysql server running on fedora virtual machine. Connection is established. But when I've restarted mysql server with this command : # /etc/init.d/mysqld restart stop is ...
1
vote
0answers
137 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. ...
0
votes
0answers
161 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 ...
0
votes
1answer
283 views

MySQL process showing in top but no errors logged

I am seeing the following in TOP 2311 mysql 20 0 1324M 646M 9188 S 0.0 17.1 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=...
0
votes
1answer
37 views

Getting the log from MySQL into a file when running MySQL commands from the command line

I am trying to get the log from MySQL into a file when executing a script from the command line. For example mysql -v mydb u- alex -p**** < please_run_me.sql > /tmp/file.log Now, the work ...
3
votes
1answer
7k views

unable to launch mysqld in arch linux

I have recently installed Arch Linux x64 and I wanted to install the LAMP stack. Everything worked fine, until I arrived to the MySQL part that I installed but can't launch. The output of sudo ...
1
vote
1answer
303 views

Mint 12 - Error updating MySQL (mysql-client-core-5.1)

I have MySQL 5.5 installed via packages.dotdeb.org. When trying to update 5.1, which is also installed, I get the following error: E: /var/cache/apt/archives/mysql-client-core-5.1_5.1.66-0ubuntu0....
1
vote
0answers
470 views

MySQL Daemon failed to start. Starting mysqld: [FAILED] [closed]

Help me! problem : sudo service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] vi /var/log/mysqld.log : 151015 05:46:26 mysqld_safe ...
0
votes
1answer
51 views

Bash script using mysql command with variables failing

I have a script to clone a vhost and associated db - however one of the mysql commands doesn't work. It fails and ends up outputting the mysql version number and 'how to use' info as if it hasn't been ...
1
vote
1answer
359 views

Modoboa 1.1.1 Deployment Errors

I tried to install modoboa follow this steps: http://modoboa.readthedocs.org/en/latest/getting_started/install.html I installed modoboa with pip install modoboa: Traceback (most recent call last): ...
-1
votes
2answers
71 views

How to convert a string into a date in a given format

Need a string in '9-2-1832' format in a '1832-09-02' format. Must be able to fill a 'date' type field in mysql.
2
votes
2answers
118 views

No space left on device on CentOS7

My machine which OS is CentOS7 have to backup 50G data into MySQL. But, there is no space left on the device. But there are many spaces on /home. How can I make user that there are enough space for ...
2
votes
4answers
12k views

setting mysql root password in CentOS 7

How can I log into the mysql 5.6 command line client and reset the root password in Centos7? I read the following at this link, but it does not work: 1) sudo service mysqld stop 2) sudo service ...
1
vote
1answer
34 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 ...
-3
votes
1answer
26 views

How can get back to directory line from mysql line

So I'm not sure what exactly do but enter to mysql and now I cannot return to directory line. I show in picture what exacly I mean: My question is: How can from this directory go in: Here I ...
0
votes
0answers
173 views

Installing mysqlnd for php 5.6 on CentOs 7

I get php warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50547 Library:50624 Also I read that I need to install mysqlnd to my server. I tried do it using: ...
0
votes
1answer
543 views

Upgrading mysql caused broken packages

I have Debian Jessie, and MySQL 5.6 from the MySQL Debian repository. This installation installes an apt sources.list.d entry that after sudo apt-get install mysql-community-server, it asks whether I ...
0
votes
0answers
19 views

shell connection mysql connection appears to be blocked

See mysql master-slave synchronization status. I error occurs in connection with the following shell mysql: $(mysql -h${Mysql_Server} -u${Mysql_Slave_user} -p${Mysql_Slave_passwd} -e 'show slave ...
0
votes
1answer
244 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 successfully installed, I entered the command ...
0
votes
0answers
20 views

Automatic Set Up of MySQL

I sometimes have call to install some bespoke software onto Linux systems and am using 'distutils' for this. In addition to this I also install some Python packagers that are not in the default set-up,...
1
vote
2answers
1k views

How to Subscribe a Bash Script as a MQTT Client

From my understanding: Client can be any device as long as it has an MQTT library running on it, from a microcontroller to a server, but must be connected to an MQTT broker over any network Broker ...
1
vote
2answers
393 views

writing mysql output to file in CentOS 7

I am trying to run the following command from inside the mysql command line client in the CentOS terminal: SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') FROM ...
1
vote
2answers
190 views

MySQL Access Denied (CentOS)

I have installed fresh MySQL server on CentOS, and started the MySQL server service with command. # /sbin/service mysqld start I checked the service and it is running. Currently I am logged in as ...
0
votes
1answer
35 views

Why is crontab executing on one server but not the other?

I have two servers on linode that have some websites on them. I created a script to see if mysql is running on the server and if it's not running then the script will start mysql. The script is on ...
2
votes
1answer
2k views

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard ...
5
votes
2answers
8k 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 Loaded:...
1
vote
2answers
237 views

install mysql - has no installation candidate

I used to install mysql 5.6 in this way.. But now.. # echo "deb http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >> /etc/apt/sources.list && echo "deb-src http://repo....
0
votes
1answer
40 views

Backup mysql database via sftp

I have recently messed up my debian server and I have only sftp access for my files. I rescue almost everything except of my database. I have no longer direct ssh access, other than in rescue mode, ...
0
votes
2answers
88 views

Tab completion does not work in MySQL command line client

I've installed MySQL 5.7.10 on my Mac using Homebrew. My Mac is running OSX 10.11.3. When I'm running the MySQL command line client, I cannot tab-complete keywords, table or column names. How do I ...
1
vote
1answer
226 views

curl: (77) pbm with the SSL CA cert (path? access rights?)

I am in root in my directory on CentOS release 6.6 and I want to do the following in order to install mysql in upper version on centOS: rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-...
0
votes
1answer
58 views

Verifying output of a command not quite working via BASH script

In attempting to verify if a remote database exists or not, I'm seeing mixed behavior with a conditional statement. Technically the statement is working (it correctly reports if database is found), ...
0
votes
1answer
70 views

Reroute mysql connection through external machine

I want (as a first step towards an external mysql proxy) reroute traffic from the local connection of mysql (on a VM) to an external proxy (on the host) which then routes it back to the VM which will ...
0
votes
2answers
45 views

How to automatically feed two arguments to program after startup? [duplicate]

I have this following script which works fine on ubuntu for starting and creating a new table for MySQL database: echo "CREATE DATABASE database_name" | mysql -u root -p After this command is ...
0
votes
2answers
41 views

how to create table with fields in command line Centos

How do I do this in command line? Below is code i saw imported to PhpmyAdmin but i don't use any interface... CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `...
1
vote
1answer
39 views

Silent MySQL Server installation

I want to install a mysql-server on a Raspberry Pi (Debian) using a SSH-connection and a bash script, which contains the installation commands. The point is, that the installation need to be done ...
1
vote
0answers
69 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 ...
0
votes
0answers
16 views

How to configure sympa with plesk root access using mysql usename admin@localhost?

I'm trying to use MySql, but username is admin@localhost. It was root but plesk changes it to admin. I also tried PostgreSQL but after it asks for the root password there is another request to access ...
1
vote
3answers
306 views

MySQLdump via crontab - Pass --password=/hashed/password/file so I can use via crontab w/o using plain text password

So I'm setting up a WordPress backup guide/making a backup schedule for myself for real. I want to do MySQL dumps daily, but the command either requires -p then user input or --password="...