An open-source, relational database management system.
2
votes
3answers
22 views
Mysql output format in Bash Script
I'm writing a bash script where I'm using mysql query in that script where the format which I'm getting is quite different.
Query:
root@debian:~# mysql -u root -ptoor super_market -h 0 -e "select * ...
3
votes
0answers
104 views
Using a NFS for gcc, Apache, PHP, MySQL, glibc
I have 7 SLES VM. I am compiling always the newest version of
gcc and all dependencies.
Apache and all dependencies.
PHP and all dependencies.
MySQL and all dependencies.
glibc and all dependencies.
...
1
vote
2answers
36 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]
...
3
votes
1answer
37 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
27 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?
...
0
votes
0answers
45 views
Nightmare importing database from old mySQL/PHP to new one
I have a system that failed on me. That system was running CentOS 6.0, PHP4 and MySQL 5 (if I am not wrong).
That database contains latin characters, letters like á, é, ç, ó, ã, etc.
From the ...
0
votes
0answers
10 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
1answer
40 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
1answer
51 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 ...
2
votes
1answer
313 views
can not install mysql-server on centos 6.7 32bit . Error: need rpm?
when I try to install mysql-server on centos with this command:
yum install mysql-server
server replies:
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds ...
1
vote
0answers
77 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
1answer
35 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
0answers
17 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. ...
2
votes
2answers
62 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 ...
0
votes
3answers
27 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?
1
vote
1answer
17 views
Munin mysql plugin silently fails
I installed this Munin MySQL plugin on a RHEL 6 machine and I'm experiencing a strange behavior.
I'm not getting any data in the Munin web page (the Categories list does not show a mysql link), but ...
-1
votes
2answers
52 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.
0
votes
0answers
103 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:
...
-3
votes
1answer
25 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 ...
1
vote
1answer
31 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 ...
0
votes
1answer
350 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
0answers
19 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 ...
0
votes
1answer
125 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
1answer
32 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 ...
1
vote
2answers
116 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 ...
0
votes
1answer
30 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
51 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
74 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 ...
0
votes
1answer
51 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
47 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
39 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
36 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
33 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
63 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
13 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 ...
0
votes
2answers
97 views
Mysql server not starting
I installed Mysql server 5.7.9 on RHEL 6.5 using mysql57-community-release-el6-7.noarch.rpm Repo. And installation was successfull but when i try to start it up and gives errors. And from ...
1
vote
0answers
29 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 ...
0
votes
0answers
18 views
MySQL Cluster node crashed, how to re-add in cluster?
We have 2 data node in mysql cluster, and one of them got crashed (totally). I have re-install new OS and now i want to re-add same node back to cluster. How to do that without re-starting whole ...
-2
votes
1answer
45 views
Executing MySql stored proc in Crontab [closed]
I have a MySQL stored proc named "item" and I want Cron to run it for me - in server of course. I'm avoiding using MySQL events to unify all my 'jobs' - backup,etc.
Any how this is what I did in my ...
3
votes
2answers
1k views
Debian 8 - Install lastest version of MySQL
After downloading MYSQL APT Repository at
http://cdn.mysql.com//Downloads/MySQL-5.7/libmysqld-dev_5.7.11-1debian8_amd64.deb
I ran the command
dpkg -i libmysqld-dev_5.7.11-1debian8_amd64.deb
...
1
vote
2answers
89 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 ...
2
votes
3answers
49 views
How to automatically handle low disk space?
Currently one of our prototypes has a very bad caching system.
In a matter of minutes it fills up it's harddrive and makes the system unusable.
What I need to do then is to restart mysql service to ...
0
votes
1answer
44 views
Sabayon 16 - MySQL Server unable to start
After installing Sabayon 16, I needed to install MySQL Server. I have followed two tutorials, but both of them fails to me. The first tutorial says to install dev-db/mysql and then execute sudo ...
2
votes
1answer
66 views
copy and symlink mysql to another disk partition
I'm using ubuntu 12.04 and have two disk partition named: /dev/sda and /dev/sdb.
my home partition and other programs are in /dev/sda.
therefor any work like database benchmark on my mysql databases ...
1
vote
1answer
140 views
limit of open files: Debian Jessies´ MySQL vs Community Oracle MySQL
I have just upgraded from MySQL Jessie 5.5 to MySQL Oracle Community Edition v5.6.
I have a particular MySQL server, that has around 230 DBs, and > 32k files/tables.
Whilst for two or three years, I ...
0
votes
1answer
29 views
unlang: sql results to local variable
I'm trying to save a resultset of a SQL query in unlang. (First time unlang for me by the way, so please don't judge me for mistakes)
The corresponding line is
Sql-Result-Set = %{expr: ...
1
vote
1answer
138 views
How do I prevent crashing my ec2 micro instance mysql db?
I have an Amazon ec2 micro instance that holds a WordPress site. Since yesterday, my mysql db keep crashing saying:
[ec2-user@ip-xxx-xx-xx-xxx ~]$ sudo service mysqld status
mysqld dead but subsys ...
0
votes
1answer
394 views
run multiple instances of MySQL CentOS7
I need to have multiple instances of MySQL running on my PC.
I did this:
yum install mariadb-server mariadb => install mysql
mysql_install_db --datadir=/var/lib/mysql => use mysql_install_db ...
2
votes
0answers
16 views
PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) [duplicate]
I am getting this error message when trying to access a php page:
PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24)
How can I solve this ...
