An open-source, relational database management system.
0
votes
1answer
12 views
upgrade mariadb 10.0.29+maria-1~jessie failed
using debian 8 with mariadb repository, apt-get dist-upgrade command failed for Mariadb Packages.
Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances
Lecture des ...
1
vote
2answers
19 views
How can I make apache to start up automatically on linux mint?
I have installed Linux Mint 18.1 Serena and I have XAMPP 5.6.28-1 on my computer. After I turn on my computer, I must run the XAMPP control panel and I must start Apache and MySQL manually.
Does ...
2
votes
0answers
26 views
AWS EC2 infrastructure
I was on a job interview today and one question I faced was:
I have my application running within a docker container on an EC2 instance (AWS Linux 64bit). The docker containers we use for the ...
0
votes
0answers
6 views
I have 3 node galeracluster in which out of 3 nodes in 2 nodes mysql services status is Active(running) and in one node it is Active(exited)
I have 3 node galeracluster in which out of 3 nodes in 2 nodes mysql services status is Active(running) and in one node it is Active(exited). And when I
execute
SHOW GLOBAL STATUS LIKE '...
-1
votes
0answers
35 views
Why is one MySQL service in a cluster Active(exited) when all of the others are Active(running)?
I have 3 node galera cluster on Linux. I am looking at the MySQL service status with /etc/init.d/mysql status
In 2 of the 3 nodes the MySQL service's status is Active(running) and in one node it is ...
3
votes
2answers
114 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
19 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
50 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
30 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
71 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
20 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
37 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
44 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
49 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
22 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
93 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
1answer
37 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
58 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
61 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
27 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
100 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
42 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
32 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
49 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
43 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
33 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
17 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
232 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
80 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
234 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
32 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
27 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
33 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
41 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
52 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
68 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
22 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
22 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
16 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
58 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
62 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
283 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
36 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
171 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
66 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
83 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
34 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
262 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~)...
