An open-source, relational database management system.
0
votes
1answer
9 views
PHP 5.5 mysql 5.6 version mismatch
I have Centos installed.
In error logs I get the error
PHP Warning: mysqli::mysqli(): Headers and client library minor version mismatch.
I have PHP 5.5 and mysql 5.6 installed.
It was suggested ...
3
votes
1answer
423 views
MySQL installed but no mysql command found
I'm trying to install MySQL 5.1.69 server community onto a RHEL 6 system (although it's outdated; I want to replicate an issue reported on this version).
I installed a MySQL 5.1 PRM, downloaded from ...
0
votes
2answers
30 views
mysqld_safe not starting after install MySQL 5.7.13 port in FreeBSD/amd64 10.3 using pkg
I have a problem with running mysql server. I've just installed FreeBSD 10.3 and I want to run here MySQL server, but process doesn't starts.
Here are all commands i gave after install FreeBSD, step-...
1
vote
1answer
14 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 ...
0
votes
0answers
13 views
Error while installing Amarok
I'm trying to install Amarok audio player on Redhat but getting error that libmysqld.so.18() required. I've installed MariaDB but still error appears.
0
votes
1answer
12 views
Trouble opening phpmyadmin login page from the browser
I followed this link to install LAMP server on my Ubuntu 16.04 OS. In the steps given, I have skipped the installation of MariaDB (I went with mysql instead). Also, there was an error while installing ...
0
votes
1answer
54 views
problems with packages
A few days ago I took a dedicated server with a centos 6 64 bits installed.
The problem is that when trying to install sentora or cpanel-whm, it shows the
following message:
Checking that minimal ...
0
votes
3answers
49 views
Installation of MySQL 5.7 on Debian 8 fails [closed]
I have a problem installing MySQL 5.7.
I downloaded the file here with Windows and put it with ftp in the temp directory of my server, because wget always timed out.
Then I executed sudo dpkg -i /...
0
votes
1answer
31 views
mysql service restarted during user being connected lead to failing service
I have performed a charset change via my.ini into utf8 and forgot a user loggen in in another terminal session, when I performed a service restart.
Initially systemd reported a problem stopping the ...
0
votes
1answer
46 views
How to open mysql backend
I just installed mysql-server with sudo apt-get install mysql-server.
How can I open the webinterface now from the browser? I did not found anything in the wiki.
On windows with xampp I just had to ...
1
vote
2answers
135 views
A script to take data from csv file and perform related operations in a database
I am new to the world of shell scripting and don't have much idea of shell scripting . My work requires me to write a script which takes phone numbers from a list of records stored in an CSV file .
...
0
votes
1answer
19 views
Running a series of scripts in MySQL
I have files named like:
File1_01.sql
File1_02.sql
File2_01.sql
File2_02.sql
I need to run all the scripts for File1 first (but these can be done in parallel), then all the scripts for File2. What'...
0
votes
2answers
111 views
Suppress warning messages from MySQL in shell script but allow errors
My log files are getting dumped with following message while running shell scripts using some underlying MySQL commands.
Here is the message:
"Warning: Using a password on the command line ...
2
votes
0answers
37 views
apt-get commands won't return
I am working on a Raspberry Pi running Raspbian, and I think I'm having a problem with my apt-get.
The problem originated with a MySQL server I was running. The server stopped seemingly at random, ...
0
votes
0answers
15 views
Log Slow Query not working
I'm trying to log slow query, here's my mysql config on /etc/my.cnf:
[mysqld]
slow_query_log = 1
slow-query_log_file=/var/lib/mysql/slow_queries.log
long_query_time = 5
log_queries_not_using_indexes=...
0
votes
2answers
204 views
How to install specific mysql 5.6.21 version on redhat?
My requirement is Mysql 5.6.21. I tried to install Mysql but it installed 5.6.31 version.
I tried following steps:
$ yum repolist all | grep mysql
It gives following output:
mysql55-community/...
0
votes
0answers
286 views
yum install error nothing to do (MYSQL, CentOS 7)
I'm trying to install MYSQL instead of MariaDB on my VPS CentOS 7. I used this command:
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
yum install http://dev.mysql.com/get/mysql-...
6
votes
3answers
485 views
How to change MySQL 'root' password using MySQL v5.7?
Current Environment :
mysql> show variables like "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+---------------...
0
votes
1answer
105 views
Install mysql-server 5.6 on Debian Wheezy
I had a messy mysql installation on my Debian server.
I got rid of everything using the dpkg --force all --purge packet on any mysql packet I could find (mysql-common, mysql-server, mysql-client, ...
0
votes
1answer
43 views
Couldn't connect to Larvel homestead database with MYSQL workbench
I am unable to connect to laravel homestead via mysql workbench
here is how i connected
but i am facing the below issue
Plz Plz help me !!!
Edit:
Here are the details as requested by Gerath ...
0
votes
0answers
12 views
Pmacct resource usage and remote data push capability
Firstly, I am interested in hacking pmacct into some Asus router firmware (n14U). I will build it from source, etc so that should be big deal. However, I am a little concerned about the resource usage ...
1
vote
0answers
122 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
...
0
votes
1answer
74 views
CentOS define same date and timezone for system and MySQL
I was watching that my droplets have different timezone between OS and MySQL. By default, I've configured all vms to Brazilian timezone (America/Sao_Paulo) through tzselect, and, assuming that MySQL ...
2
votes
1answer
51 views
MySQL command line - bind <UP> key to a backward command search
With mysql command line client on Ubuntu 14.04 I could bind UP to a backward command search by adding the following lines to ~/.inputrc
# type a word, hit up and a search is performed
# "\e[A": ...
0
votes
0answers
30 views
How to force rsyslog ommysql use UTF8?
I'm using ommysql in rsyslog for transferring data into MySQL
$ModLoad ommysql
local6.* :ommysql:localhost,Syslog,rsyslog,1
but Cyrillic data goes like "·Ð¾Ð²Ð°Ð½Ð¸Ðµ иÑ�точнÐ" in ...
2
votes
3answers
162 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 * ...
4
votes
0answers
123 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
141 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....
3
votes
1answer
91 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
112 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
30 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
62 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
87 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
1k 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
192 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
65 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
25 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
218 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
30 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
39 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
99 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
248 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
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 ...
1
vote
1answer
47 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
662 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
21 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,...
0
votes
1answer
368 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
36 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
361 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....
