An open-source, relational database management system.
2
votes
2answers
29 views
Is it possible to install mysql 5.7 on Amazon Linux AMI?
I tried installing and I am seeing the error
Error: Package: mysql-community-server-5.7.17-1.el7.x86_64 (mysql57-community)
Requires: systemd
You could try using --skip-broken to work around ...
0
votes
1answer
10 views
EasyApache 4 Migration Issue
One of server is hosting several domains with their wepages mostly in php. Server was running eayapache3 with php5.5. One of the domain asked to enable php5.6 recently. So we migrated the server from ...
0
votes
2answers
47 views
password is always passw0rd? Why?
Per telecomworld:
FreePBX Operator Panel (FOP)
The secret code for performing transfers and hangups in the Flash
Operator Panel is passw0rd (zero not the letter O)
I'm on Elastix 2.5 and am ...
0
votes
2answers
29 views
How to view only the first row or a table in MySQL?
I want to view one row of a table in a MySQL database to see what kind of information is stored in the table. What is the MySQL command and syntax to accomplish this, after > use [database_name] ...
3
votes
2answers
45 views
MySQL root account without password?
I've just installed MySQL server with no password on root account. I was prompted to enter root password 3 times and I left it blank all three times because I don't want to use password. But now it ...
0
votes
0answers
12 views
Move mysql/postgresql from /var/lib using systemd on CentOS 7.2
What's the proper way to move /var/lib/mysql and /var/lib/postgresql using systemd and symlinks on CentOS 7.2, ideally without editing conf files?
I found a way to start both that doesn't use systemd,...
0
votes
1answer
20 views
MySQL install aborts with error
I'm trying to install MySQL on Raspbian Jessie. This has worked smoothly on another machine with an identical setup; however, on the second one, I can't get it to work.
During package configuration, ...
0
votes
0answers
32 views
How to create new MySQL database with encoding via BASH script
I have one bash script for installing wordpress and want to add also mysql installer to easly can install database
#!/bin/bash
dr=$1
db=$2
zDir="latest.zip"
wpInstall="https://wordpress.org/"$zDir
...
0
votes
0answers
37 views
Problems with MySQL 5.7 and reset root password when use mysql_config_editor
I am using MySQL 5.7.17 on Debian Jessie and wanted to dump the database using mysqldump with mysql_config_editor.
The steps I did for the mysql_config_editor. They are:
mysql_config_editor set --...
0
votes
0answers
11 views
Can't configure the 'wsrep' in MariaDB/MySQL?
When I try to set wsrep in "/etc/mysql/mysql.conf.d/mysqld.cnf " like this:
[mysqld]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
...
0
votes
2answers
20 views
Download / Compile local version of mysqldump
I am using a webserver that is administered by someone else. The version of mysqldump on this server is from 2011:
$ mysqldump --help
mysqldump Ver 10.13 Distrib 5.1.63, for debian-linux-gnu (x86_64)...
2
votes
1answer
76 views
MySQL dependencies conflicts
I have installed Cloudera Server and Agent successfully, but I am facing issues installing MySQL.
I have setup a local repository for this installation as I require offline installation.
How do I ...
0
votes
0answers
21 views
Is there an easy way to know what mysql commands are taking so much time?
It looks like I have tons of mysql commands. That increases my disk utilization to 100%
I want to know what the commands are or track things down. I have so many users on my server hosting so many ...
1
vote
0answers
24 views
Antergos MariaDB problems
I've just installed the mariadb package and doesn't work (doesn't start), I've these outputs:
systemctl status -l mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/...
0
votes
1answer
44 views
After fresh install of mysql-server, can't log in with `mysql root -u`
EDIT: I believe this is actually a duplicate of http://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04
I used the top answer from that page and ...
2
votes
1answer
48 views
Dependency issue during deleting mysql in Debian stretch
I need to install mysql-server-5.7, but the highest version in debian repo is 5.6. I've tried to find the way to install 5.7. Can't remember all tried, but I didn't manage to to that. Instead of it I ...
0
votes
1answer
24 views
Error 2002 MYSQL OS X 10.11
I had several installations of mysql on my laptop, like brew mysql, brew mariadb, MAMP and plain old Mysql. Now I'm just trying to use plain old mysql after I tried deleting anything that may be ...
0
votes
0answers
72 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
35 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
30 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
41 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
39 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
26 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
1answer
198 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
71 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
158 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
28 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
24 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
39 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
46 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
59 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
21 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
21 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
55 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
59 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
228 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
31 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
105 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
52 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
77 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
31 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
208 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
56 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
28 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
206 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
88 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
163 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 ...
