The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
14
votes
5answers
35k views

How to change MySQL 'root' password using MySQL v5.7?

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +---------------...
1
vote
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 ...
1
vote
2answers
866 views

Why is the config file in /etc/munin/plugin-conf.d/ ignored?

I have a Munin script /etc/munin/plugins/mysql_replag that queries a MySQL server to check the status of a master-slave replication: #!/bin/sh # Plugin to monitor the Seconds_Behind_Master of ...
0
votes
0answers
17 views

mysql - importing Tablespace: Lost connection during query

iam trying to recover innodb table which has 1.5M rows from ibd file ( 5.5 GB ) this is the exact steps i do: getting create table query using mysqlfrm command create the table discard tablespace ...
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
2answers
54 views

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

I'm running on an Ubuntu 19.04 distro and have a Dockerfile which when we reach step 7; Step 7/11 : RUN (/usr/bin/mysqld_safe &); sleep 5; mysqladmin -u root -proot create wordpress we get; ...
-2
votes
1answer
32 views

Apparent different sizes when attempting to export a particular mysql database

In a quite old-versioned CentOS-Bash "shared server" environment, I ran the following commands: current_date="$(date +%F-%T)" db_user_name_and_db_name="db-username_db-name" war="$HOME/public_html" # ...
-2
votes
0answers
35 views

Error While Start Service mysql

I'm stuck on starting mysql service in my Kali Linux machine. When i hit this command root@kali:~$sudo service mysql start Job for mysql.service failed because the control process exited with error ...
-1
votes
0answers
15 views

proFTPd with MySQL support, cannot change directory ('CWD' command)

I followed the tutorial “Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Fedora 9” (https://www.howtoforge.com/virtual-hosting-with-proftpd-and-mysql-fedora9) to install proFTPd on Red Hat ...
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 ...
-2
votes
1answer
29 views

JSON_TABLE problem

I have a JSON structured like that ... { "market_order_line_details__c":[ { "PriceItem__r.Catalog_Item__r.Parent_Catalog_Item__r.Parent_Catalog_Item__r.Calendar__r":{ "...
2
votes
3answers
610 views

How can I install Mysql on Debian 10 (buster)?

I've tried to follow the official guidance on installing MySQL on a fresh Debian install. So I went to https://dev.mysql.com/downloads/repo/apt/, downloaded mysql-apt-config_0.8.13-1_all.deb, Run ...
0
votes
1answer
14 views

MySql Community Server port changing

I've installed mysql-community-server 8.0 on Oracle Linux 7 using official documentation It have been installed successfully, but: # service mysqld start resulted in: Redirecting to /bin/systemctl ...
3
votes
3answers
11k views

MySQL permission denied error even after setting security context for SELinux on VM

I have MySQL installed on CentOS (detail versions given below). My OS is a VM machine and not a physical machine, the directory /data/mysql is a local disk (virtual). I suspect I might need to do some ...
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 ...
0
votes
1answer
18 views

script to get all long running mysql queries

I need to get the long running queries on mysql server for alerting purpose. Found a way but it doesn't work: show full processlist; It shows Select sleep(10); but doesn't show select * from ...
7
votes
4answers
37k 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....
-2
votes
0answers
19 views

MySQL connectivity error on webserver

I tried to move to MySQL directory from /var/lib/mysql/ to /home/mysql/. The transfer did not complete due to some reason, so I moved back all the files that were transferred. Everything was working ...
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
31 views

How to write MySQL query in text file and run in linux

I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database. I am able to call the .sql file by running .sh file in linux, but the sql query is not ...
0
votes
1answer
48 views

Installing mysql in debian10

I am new in debian and I'm trying to install mysql, But when I do these commands : sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server then this error will come up : ...
3
votes
4answers
19k 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-...
1
vote
2answers
56 views

Convert mysql response from VM into specific format

Using a shell job I am getting a response from mysql in below text format, In a text way as requested +-------+ |    A    | +-------+ |   36   | +-------+ +-------+ |    B    | +-------+ |  ...
1
vote
0answers
23 views

How can I separate MariaDB's mysqld from MySQL 8's mysqld process to solve A mysqld process already exists error?

My goal is to have MariaDB 10.1 and MySQL 8 on the same Ubuntu 18.04 server. I was able to setup MySQL 8 successfully, and got stuck almost at the end while setting up MariaDB following this guide: ...
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....
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 ...
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: ...
0
votes
1answer
30 views

Why does gunicorn w/ workers as a daemon kill MySQL?

So, I've recently deployed my first Flask app with gunicorn. During deployment, I encountered the most peculiar issue. I had created a systemd unit file (the following is the working, functional ...
0
votes
1answer
7k 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: ...
1
vote
1answer
225 views

Changing MySQL Temporary File - Permissions Error

At the moment, MySQL Server is using /tmp as it's temporary directory, and I'd like to change that, because it's running into storage issues. Following this post: https://encylia.com/2015/02/06/how-...
0
votes
1answer
258 views

“E: Sub-process /usr/bin/dpkg returned an error code (1)” while trying to install mysql-server-5.6

Trying to install mysql-server-5.6 for 16.04 with sudo apt -f -y install mysql-server-5.6 but am getting the following return WARNING: apt does not have a stable CLI interface. Use with caution ...
2
votes
2answers
978 views

MySQL won't start

I'm using a debian system. I could not start my mysql after the partition went full - I received the message "ERROR: The partition with /var/lib/mysql is too full!" I found a recommendation to delete ...
1
vote
0answers
13 views

Xampp isn't working properly!

I have been facing a problem for 3 days. When I install xampp on my windows-10, it's only working for the first time. But when I shut down my pc, then I can't find it on installed app and also it wasn'...
4
votes
1answer
7k views

Changing password of postfix user account directly in the MySQL database

I need to change a password of a postfix user account mailbox directly in a MySQL database; however I have no idea of the format used. Here is the table: SELECT username,password FROM mailbox LIMIT ...
1
vote
1answer
1k 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. ...
1
vote
1answer
26 views

Sandbox-HDP The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

I installed MySQL and the MySQL community server on my Hortonworks HDP. I started service and tried to change password /usr/bin/mysql_secure_installation Securing the MySQL server deployment. ...
1
vote
1answer
33 views

MySQL&PHP - Aborted connection to db: (Got an error reading communication packets)

PHP version 5.6 I have a PHP program (running in CodeIgniter 'CI_VERSION', '2.1.3') looping through 100 items to process. Apache (via Codeigniter) will give me 500 Error and no indication anywhere ...
0
votes
2answers
967 views

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7. I researched a lot but could not find any link which gives step by step procedure. Can someone please give me steps to be followed to ...
1
vote
2answers
1k 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 ...
0
votes
0answers
14 views

yum installing mysql-server 5.5 instead of 5.7 on Amazon Linux

My understanding of yum is that it should default to installing the latest version of a package available in all the repos enabled. The default repos installed in Amazon Linux 1's AMI include the ...
2
votes
1answer
309 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I have a password in place

I have been trying to install phpmyadmin on my Debian 9 (stretch) system, I already have apache, php and mysql installed and working. When I run sudo apt-get install phpmyadmin it downloads but the ...
0
votes
0answers
29 views

How to generate the conection string to mysql-server in linux

I have an asp.net core app with user authentification working fine in my windows machine (I've got MySQL server for windows). I want to deploy it on my Linux machine. Everything works fine except for ...
17
votes
3answers
32k 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
1k views

Cann't start MySQL on my Linux server with Centos 7 OS

I have already installed MySQL in a Server (Centos 7) by the following commands: yum install -y mysql yum install -y mysql-server yum install -y mysql-devel After the installation, I type mysql and ...
0
votes
1answer
922 views

error on opening mysql workbench on fedora 23

I have installed mysql-workbench on Fedora 23 Virtual machine (VMware) using the command : yum install mysql-workbench Now when I tried to issue the command mysql-workbench from terminal I am ...
1
vote
0answers
34 views

SSH Tunnel/Reverse Tunnel Question

I am attempting to daisy chain tunnels/ports to access mysql on a secured server. Without opening up iptables, I would like to, from my local machine: mysql -uadmin_user -p -hlocalhost:8002 and ...
1
vote
0answers
24 views

Port not available on the same network(MySQL with docker)

I have two servers in one network. 192.168.202.5 netmask 255.255.255.0 192.168.202.32 netmask 255.255.255.0 On second server I start MySQL using Docker Compose. docker ps CONTAINER ID ...
0
votes
1answer
1k views

Can't seem to connect to my Debian Mysqli Server?

So I have a simple PHP script which I attempted to do something along the lines: $db = mysqli_connect("localhost", "root", "PASSWORD HERE", "database name"); mysqli_query($db, "SELECT STATEMENT HERE")...
0
votes
1answer
1k views

Moving from InnoDB to TokuDB

I'm running MariaDB 10.0.x and I would like to move from InnoDB to TokuDB. When using ALTER TABLE <> ENGINE=TokuDB; everything goes fine for the Wordpress websites. Unfortunately the Magento ...
0
votes
1answer
2k views

Modifying SELinux settings to allow for MySQL to run on CentOS7

I'm trying to install MySQL 5.6 on Cent OS 7 with SELinux enabled and am trying to get past the error (in /var/log/audit/audit.log): type=AVC msg=audit(1424111345.853:558): avc: denied { execmem } ...