An open-source, relational database management system.
-1
votes
0answers
44 views
Manipulate output from two loops
I have two queries and I want to run them simultaneously in the loops.
Basically, both queries give outputs of domain names and I want to remove a domain name from the output completely if the ...
0
votes
0answers
16 views
Bootstrapping Galera on RHEL7.2 systemctl: unrecognized option '--wsrep-new-cluster'
I am trying to set up Galera cluster via Puppet and I have an additional (probably misguided) requirement to use "Red Hat supported" RPMs. The problem I have due to this requirement is that bootstrap ...
0
votes
1answer
17 views
What replaces mysql-*-5.6?
I'm following these instructions to get MythTV set up on a Raspberry Pi 3. One of the steps is to install mysql (both server and client):
sudo apt-get install mysql-server-5.6 ntp libicu55 libqt5sql5-...
3
votes
0answers
26 views
Problem with MySQL timezone
I have installed MySQL,version 5.6.16.My OS is FreeBSD,version is 9.3.MySQL installed on jail.When I check date I see Thu Nov 17 15:22:14 AMT 2016,I see this output also on the system.In MySQL,when I ...
0
votes
0answers
16 views
ArchLinux can't get MySQL Workbench to connect to server
I just installed the mysql-workbench 6.3.8-1 package from the AUR. I started it and before making my connection I clicked on the Test connection button and got the following error:
Failed to ...
0
votes
0answers
29 views
Mac install MySQL from a shell script
I want to programmatically install MySQL to a Mac system running OS 10.11.6 El Capitan, so once the .dmg has been downloaded the script unpack it with the command:
sudo hdiutil attach mysql-5.7.16-...
0
votes
0answers
15 views
mysqld_safe restarting, but mysqld remains dead
I'm relatively new to Sys Admin, looking for assistance w/ a problem on my Amazon Linux EC2 server running Wordpress.
Occasionally, the database goes down. To start debugging, I check mysqld status. ...
0
votes
1answer
16 views
Fedora and remote mysql in httpd [closed]
Hello I have problem with my fedora (version 24) httpd server (localhost). I'm install and configure php mysql httpd (and allow rewrite), but when previously I'm using ubuntu I connect to my remote ...
1
vote
2answers
130 views
Cannot login root user after upgrading MySQL from 5.6 to 5.7
After upgrading MySQL from 5.6 to 5.7, I am not able to log in as root:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I found the following in the log:
2016-10-...
1
vote
0answers
41 views
Yum skip-broken problem
I'm trying to install mysql-connector-odbc using yum.
It gives me this error.
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red ...
1
vote
1answer
104 views
SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) but 'localhost' works
Cent os Apache + php + MySQL from php when you try to connect to the MySQL at the address 127.0.0.1, an error occurs. If you replace a line 127.0.0.1 to localhost everything works without problems. ...
0
votes
2answers
27 views
User for mysql database [closed]
On a test Debian server, I'm using root as user for mysql. Then for each Wordpress site I have, I have this in the php config file:
define('DB_USER', 'root');
define('DB_PASSWORD', '...');
Is this "...
0
votes
1answer
19 views
ODBC Authentication with .pem files on Ubuntu server with Python
Using the below 3 PEM files I am able to connected successfully to a MySQL database on windows threw setting up a Data Source. (No problems here)
client-key.pem
client-cert.pem
ca-cert.pem
But I ...
0
votes
0answers
32 views
Python script executing MySQL SP ends with Errcode 28 - need help interpreting log
Tue Oct 18 16:49:59 2016|Traceback (most recent call last):
File "Python-Script_0.py", line 156, in <module>
main()
File "Python_script_0.py", line 110, in main
update_Database()
File "...
0
votes
0answers
29 views
mySQL memory usage increasing day by day
I'm using New Relic to monitor our servers, one for web, another for mysql, and the mySQL one worries me because the physical memory usage increases everyday. Every week it uses up 2% more than the ...
0
votes
1answer
31 views
Mysql_connect(): Can't connect to local MySQL server through socket in Linux
i am trying to connect mysql DB with xampp in linux centos . but i am getting error like this .
Mysql Error : 2002- mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/...
3
votes
0answers
42 views
OOM Killer keeps killing mysqld
I run a CentOS vps to host a few websites with cPanel/WHM but every now and then, my websites stop working because it can't establish a connection to the mysql database.
Looking at the messages log, ...
0
votes
1answer
17 views
Is it possible to read from MYSQL-database to get valid IP-Adresses for Pingtable
is it possible that iptables reads the IP-Adresses it should packages from from a MYSQL-database?
0
votes
0answers
14 views
start mysql caused the load average highly
today when i open the mysql server ,then it suddenly pop up some tips
/usr/bin/mysqld_safe: line 166: 24085 Killed nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --...
1
vote
0answers
15 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 ...
4
votes
1answer
50 views
How to pause MySQL before taking an LVM/ZFS snapshot?
How can I instruct MySQL to complete all "in-progress" transactions, but to delay starting new ones (without kicking clients off) until I have taken a ZFS or LVM snapshot (which takes less than a ...
0
votes
2answers
41 views
How to disable Apache and MySQL autostart when PC is turned on?
I'm using Linux Mint 18 XFCE and installed Apache, MySQL and PHP packages to make local development.
Apache and MySQL services are always active and start from the beginning.
How can I disable those ...
2
votes
2answers
170 views
SSH tunnel via MySQL Workbench
my new production server is only visible via ssh double tunnel. I can reach targetHost over Ubuntu's 14.04 console simply executing command ssh targetHost and than executing mysql cli on remote ...
1
vote
1answer
24 views
Bash script / Mysql query
I want to create a bash script with query:
mysql -D $Database -u $User -p$Password \
-e "UPDATE example SET example='["TEXT","TEXT","TEXT"]' WHERE example='example';"`
My result in table:
[...
0
votes
2answers
60 views
Mysql queries from bash file
I'd like to run multiple MySQL queries and save them to specified files. Queries are saved in a bash script, queries.sh, e.g.:
cat queries.sh
mysql -u <user> -p <DBname> -e "select Col1 ...
1
vote
0answers
40 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 ...
0
votes
0answers
63 views
Centos remote mysql - still cannot connect. Disabled IPtables, setup my.cnf. Very confused!
I know this question is posted a lot and I've tried many suggested solutions to no avail.
I'm trying to setup mysql on centos to allow remote connections.
My test is to run
telnet IP_ADDRESS 3306 - ...
0
votes
0answers
28 views
Why is the MySQL 5.7 random password not logging on CentOS 7.2?
I'm finding myself googling in circles this morning trying to do something that is fairly routine, all due to a nasty combination of otherwise simple problem conditions.
I'm configuring a Vagrant ...
2
votes
1answer
127 views
broken packages when installing mysql 5.6 using apt-get
I am trying to install mySql 5.6 on my Linux machine.
I tried
>apt-get install mysql-server-5.6
but I am getting the following error:
mysql-server-5.6 : Depends: mysql-common (>= 5.6.22-1~)...
0
votes
0answers
47 views
rhel7: mysql-community-libs conflicts with the installed packege mariadb-libs
On a RHEL 7 system when I try to install mysql 5.1 version, it has a conflict with mariadb-libs. I tried to remove mariadb-libs, other packages like net-snmp and postfix get removed. I do not want ...
0
votes
0answers
21 views
mysql::router losing connection during data import
I have a small AWS EC2 instance that is a fairly simple LAMP setup. I am experimenting with migrating the MySQL install to a remote AWS RDS instance, however I wish to mask the remote IP so that the ...
2
votes
1answer
127 views
Apache not running on Debian 8
I'm trying to install a LAMPP Server on my freshly installed Debian distro, and I'm having issues running seeing the Apache site when I type localhost on my web browser. I've been doing research for ...
1
vote
3answers
73 views
Copy sql file over ssh with accents
I'm trying to migrate one database from server A to server B.
The database is mysql. This database has some records with character like ç, ã é, ...
The database encoding is UTF8
So on server A I ...
0
votes
1answer
120 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
660 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 ...
1
vote
3answers
178 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
37 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
1answer
34 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
117 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
123 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
111 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
100 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
620 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
23 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
834 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
43 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
2answers
285 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
646 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
2k views
How to change MySQL 'root' password using MySQL v5.7?
Current Environment :
mysql> show variables like "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+---------------...
0
votes
1answer
461 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, ...
