Questions tagged [mysql]

An open-source, relational database management system.

2
votes
2answers
7k 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 was successfully installed, I entered the ...
0
votes
2answers
38 views

PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/

I am working with php(7.3) and mysql in linux machine. But I am getting PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/ error in apache2 log file (/var/log/error.log). I ...
0
votes
0answers
8 views

Error using mysqlfrm to restore database

Good afternoon. I need to restore a base named "bignew", and I have .frm and .ibd files only. As my SGBD, I'm used XAMPP in a Linux Mint 19. Reading many posts, I opted for install and try mysqlfrm. ...
14
votes
4answers
27k views

How to pass password to mysql command line

I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it: $ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver Enter password: (...
0
votes
1answer
42 views

SElinux configuration of symlinked /etc/my.cnf -> /app/program/my.cnf

Please advise me of whether it is possible to configure SElinux context in a way that MariaDB would pick it up. current configuration: ls -lZ /etc/my.cnf lrwxrwxrwx. root root system_u:object_r:...
0
votes
1answer
1k views

Mysql database didn't connect through sqlyog or any other mysql software?

I can connect to a MySQL server through a browser and also I can show all database list through PuTTY. But when I try to use sqlyog or running the mysqldump command through PuTTY it shows this error: ...
2
votes
3answers
15k views

Install libmysqlclient on CentOs 7

I am trying to build mysql-shell 1.0.11 from src. RPMs are not an option when I am installing. One of the requirements is libmysqlclient 5.7+. I have installed mysql++, mysql++-devel, mysql-...
5
votes
4answers
10k 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
0answers
72 views

mysql taking 100% of CPU

I had a problem with my VPS like a week ago, and I had to completely reinstall it for it to work. It worked, but just for a while. Everything was alright until now, I really don't know what the ...
1
vote
2answers
1k views

Centos 7 - Recover mysql db from data files .frm and .ibd

I have migrated my operating system from Windows to Centos 7 without getting backup of mysql through mysqldump. Now I have mysql data files .frm and .ibd . I want to migrate them How can I migrate ...
4
votes
1answer
88 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 ...
-1
votes
0answers
21 views

Problem with MySQL: “Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'”

I'm having trouble starting MySQL. When I use the sudo mysql -u root -p command, it asks for the password and then displays this error: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost'...
1
vote
1answer
113 views

Bash Parallel MySQL Dump

I have a project on AWS which will eventually have over 100 client databases each estimated in the 1~2GB size. I need to do daily backups of each database via mysqldump not the standard AWS RDS daily ...
0
votes
2answers
3k 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 ...
4
votes
5answers
10k 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
0answers
24 views

Mariadb running out of memory

I have an old web server that's been running for some time, with regular updates. For the last month it's been crashing every few days. I tracked it down to: $ dmesg Out of memory in UB 136: OOM ...
0
votes
0answers
9 views

MySQL Replication from older master to newer slave - Unknown system variable 'binlog_checksum', 'SERVER_UUID'

So, here is the master: [04:18] [master ~] # mysql -V mysql Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using readline 5.1 And slaves: [08:37] [slave1 ~] # mysql -V mysql Ver 14.14 Distrib 5.7....
2
votes
1answer
1k views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
5
votes
1answer
16k views

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded mysql

mysql is giving me this error when I try to access it for the first time. It's not working for me; I have Parrot OS, which is based on Debian Jessie. The problem started with adding the mysql ...
0
votes
0answers
19 views

Pacemaker cluster service can't start properly Couldn't mount filesystem

I have 3 nodes MySQL cluster on RHEL 7.5 with DRBD, Pacemaker and after start cluster getting following error. How can I overcome ? [root@db1 ~]# pcs status Cluster name: mysql_cluster Stack: ...
-1
votes
0answers
48 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm on Linux Mint, and following the instructions here to reset the MySQL root password. ~$ sudo /etc/init.d/mysql stop [ ok ] Stopping mysql (via systemctl): mysql.service. ~$ sudo mysqld_safe --...
1
vote
1answer
1k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server. mysql -u root -proot csv_imports -e "LOAD DATA INFILE '/var/www/html/$...
0
votes
1answer
27 views

MySQL - OS tied users

So, I'm trying to find this option and I can't find it in the docs. I need to know if there is a way in MySQL in which every user on the OS is also a User on the dB. Just to clarify, when using ...
0
votes
1answer
36 views

How to script SSH connection using keypair and password?

I managed to login to my hosting provider manually with this command: ssh -i /path/to/key-ssh me@mydomain.com The server then asks for a password, and login succeeds. Now I want to automate a ...
1
vote
1answer
53 views

problem with apt upgrade when install MySQL in Ubuntu 19.4

i trying to install mysql in ubuntu 19.4 but i can't upgrade with sudo apt upgrade this is the output ; astrix@astrix:~/Downloads$ sudo apt upgrade Reading package lists... Done Building ...
1
vote
1answer
26 views

How to get CPU usage in MySQL per user? [closed]

I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
1answer
47 views

nextcloud on docker - error initializing database

When starting my nextcloud container with docker-compose up I encounter the error: db_1_7bb6e5f5b725 | Initializing database db_1_7bb6e5f5b725 | mkdir: cannot create directory '/var/lib/mysql//mysql':...
0
votes
1answer
58 views

fetch dependencies while install deb with ansible

i'm trying to install mysql 8.0.15-1debian9 on a debian 9 server the problem is that mysql only provides the latest version of mysql in their apt repository which is 8.0.16-1debian9 however 8.0.16-...
0
votes
0answers
27 views

How much space does it require to install php, mysql and phpmyadmin on CentOS 7? [duplicate]

I use ovh.com self managed VPS. The plan name is 'VPS 2018 SSD 1'. It offers 2 GB RAM and 20 GB disk space. I have only php 5.5 installed. When I try to install phpmyadmin, it throws an error saying '...
0
votes
2answers
3k views

CentOS define same date and timezone for system and MySQL

I realized that some of my droplets in Digital Ocean have different timezone between OS and MySQL. By default, I've configured all vms to Brazilian timezone (America/Sao_Paulo) through tzselect, and, ...
0
votes
1answer
178 views

Save daily mysql row count change in RRD

EDIT: To make things clear: I have an integer called $blocks or something, which increases everyday. I want to make a graph with RRDtool, that shows the "increased" amount for everyday. So if my $...
0
votes
0answers
15 views

Truncated incorrect DOUBLE value: 'null'

When I am running the query in MySQL from Linux server I got the error i.e Truncated incorrect DOUBLE value: 'null' Same query run in MySQL from Windows server it was working. UPDATE ...
1
vote
2answers
3k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld....
0
votes
1answer
45 views

sed: Match this comma or that, but not both

I have a huge mysql dump that I'm using sed to delete unneeded rows (very much faster than deleting from table) and each line of the dump is in the format INSERT INTO table_name VALUES ("somevalue", ...
6
votes
4answers
22k 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....
0
votes
2answers
124 views

Open source MySQL performance tool

Are there any open source MySQL performance tools for optimizing SQL queries?
2
votes
1answer
2k views

phpmyadmin doesn't work after installing php5-mysqlnd

I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute ...
0
votes
1answer
1k 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 ...
1
vote
1answer
2k views

How to install mysql-server 5.6 on RHEL 5.8 (when MySQL-server 5.0 is already installed)

I want to install mysql-server 5.6 on RHEL 5.8, but when trying rpm -i or rpm -Uvh it complains that I already have version 5.0 on there. I am happy to replace, upgrade or install another instance.
0
votes
1answer
91 views

Pass output from metadata call to MySQL

Reference: How to pass password to mysql command line I want to grab returned metadata from an AWS EC2 instance and set a new mysql password based on this data. I need assistance with the script ...
12
votes
4answers
39k views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
1
vote
2answers
3k views

How to view a list of previously run MySQL queries in a live feed format?

How do I view the last run queries in MySQL in a live feed format? I want to leave my terminal window open and just have MySQL queries pop up on the screen whenever something is run. I know I can do ...
2
votes
6answers
3k views

I can not install MySQL using yum on Centos7

I've installed centos7 recently, but, when I am trying to install MySQL using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
1
vote
1answer
66 views

How to know if a mysql user has all (or some) privileges on a certain DB?

How to know if a mysql user has all (or some) privileges on a certain DB? Of course, I don't ask how to do so with phpmyadmin, rather, with the mysql CLI. I aim to gather as much as basic data on a ...
0
votes
3answers
2k views

How to know list of applications installed in my server? [closed]

I got one LINUX server in which Oracle LINUX 5 is installed. I have installed MySQL 5.1.73-community version. Now, I have to configure the variables. When I checked available memory through cat /proc/...
0
votes
0answers
118 views

Mysql failed because a configured resource limit was exceede CentOS 7

Mysql is down on my vps server and i tried to restart, stop then start, but nothing works. The error i am seeing every time is this [root@vps ~]# service mysqld restart Redirecting to /bin/...
1
vote
1answer
2k views

Creating MySQL database and user without password

I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: ...
1
vote
0answers
26 views

Having trouble with connecting to MySQL server [closed]

I'm using a Dragino LG01 gateway which is running a Linux system. I want to connect the gateway to a MySQL database (using XAMPP). There is a tutorial for doing this but I am still having problems. ...
0
votes
1answer
6k 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: ...
0
votes
1answer
570 views

How to reconfigure PHP

We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I have to install PHP by using this guide PHP installed successfully but ...