Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
5
votes
4answers
3k views

Selinux is denying access to mysqld

I have a script that dumps a mysql database. It then compresses the file and this gets stored in my home folder by using cron. The problem is I seem to be getting an error message. mysqldump: ...
6
votes
1answer
8k views

MySQL stop/waiting issues; “can't connect … through socket” [duplicate]

So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
0
votes
3answers
54 views

Login into Mysql without startx

I have had install Damn small Linux(DSL) 10 in Virtual Box with MySQL 5. I created already a database with a Table and Data in it. I can access it over the terminal with the following line: mysql -u ...
3
votes
1answer
1k 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 ...
4
votes
3answers
7k views

Add 30 days in date

Using bash or mysql , how can I add 30 days in user expiry table? Example I have DB name USERS and table expiry like this: USERNAME EXPIRATION JOHN 2015-09-26 I want the command to take ...
1
vote
1answer
134 views

MySQL Java connector still using old java version?

Installing mysql-connector-java-8.0.15-1.el6.noarch.rpm (available here ) shows libgcj package as a dependency. Installing libgcj creates below file: /usr/bin/gij $/usr/bin/gij -version java version ...
11
votes
3answers
23k views

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: ...
0
votes
0answers
1k views

Wordpress site hosted on Digital Ocean - 100% CPU usage

TL;DR - when there's traffic (around 900) our sites' CPU reaches 100%, slow down and crush. INTRODUCTION Our company holds more than 40 content websites, hosted on Digital Ocean, using Wordpress CMS....
1
vote
1answer
58 views

How do I capture this mysql output message in a variable?

I have this line in my script: mysqlinsert=$(/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot --password=notmyrealpassword << EOF $mysqlrun) Despite what it returns, the ...
1
vote
1answer
3k views

How to fix this mysql permission problem?

I'm trying to get rails dbconsole to work (Rails 3.2.6). The problem is that when I run the command, I get: gems/railties-3.2.6/lib/rails/commands/dbconsole.rb:81:in `exec': Permission denied - /usr/...
1
vote
1answer
1k views

systemctl status mysqld.service shows activating

I have configured MySQL 5.7.25 instance using Linux Generic Binaries on a separate mount point (instead of default locations) on a test server (RHEL 7.4). The systemd support, in this case, must be ...
1
vote
1answer
48 views

Why is mysql server accepting nonlocal request, while postgresql server is not?

By default configurations, why is mysql server accepting nonlocal request, while postgresql server is not? $ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 ...
1
vote
2answers
94 views

Why does mysql server not accept nonlocal connection request, but still listen on a tcp port?

A mysql server with default settings is listening on a port on a machine: $ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 EDT Nmap scan report for ocean....
2
votes
1answer
824 views

Ubuntu 18.04 LTS: Problem with dependencies installing MySQL 8.0 server

I'm trying to install MySQL on Ubuntu 18.04. To do that, first I have donwload the package with the command: wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb And then, run the ...
0
votes
1answer
351 views

Not able change MySQL password on the mac

I forget my MySQL password. and I followed almost all the ways on the Google. But I'm still not able to change MySQL password. and I correctly wrote commands. What's the wrong with this? I really ...
2
votes
1answer
66 views

How can I find out information about a service?

$ nmap -p0-65535 192.168.0.142 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-10 17:53 EDT Nmap scan report for ocean (192.168.0.142) Host is up (0.000031s latency). Not shown: 65531 closed ports ...
1
vote
2answers
70 views

Why can't I connect to mysql via the browser but via the terminal with php?

I would like to display a MySQL table in the browser with PHP and created the file demo-db.php <!DOCTYPE html> <html> <body> <?php $servername = "localhost"; $username = "...
3
votes
3answers
2k views

rlwrap: mysql autocompletion not working

Normally, autocompletion works fine in mysql command-line client (mysql-client-5.5). I have a table called booking. When I type the letter b and pres TAB the name of my table gets autocompleted: ...
0
votes
1answer
2k views

Install libmysqlclient 5.5.3 on Centos 6

I'm installing Drupal 8 on my Centos 6 server. To do this I needed to upgrade both PHP and MySQL. However, I'm now getting the following error message: The libmysqlclient driver version 5.1.54 is ...
0
votes
1answer
599 views

Couldn't connect to Larvel homestead database with MYSQL workbench

I am unable to connect to laravel homestead via mysql workbench here is how i connected Homestead Connection http://simple.harry.zone/linux/homestead_connect.png but i am facing the below issue ...
2
votes
1answer
4k views

MariaDB won't start, even after reinstalling

I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists. Here's the output when i ran systemctl status mariadb.service: ...
6
votes
6answers
34k views

MariaDB - dependency problems - leaving unconfigured

I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was ...
0
votes
0answers
18 views

How to set up query-cache-type in Percona server 8.0

I installed Percona server 8.0 on Debian 9 with memory 1 G. When I set up these in my config file : query-cache-type = 0 query-cache-size = 0 I got this error: [Server] ...
0
votes
0answers
25 views

How to safely handle gtid_purged when adding replication channel, but len(GTID_PURGED) > 1024?

I'm adding a channel to a multi-master mysql slave. In the past, the procedure has been: import new db from a mysqldump, stop slave, record value of gtid_purged, reset master, manually set ...
3
votes
5answers
27k views

error processing package mysql-community-server during apt-get upgrade

How can I solve this problem? root@ip-*******:/# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done ...
0
votes
1answer
33 views

Is there a way to retrieve a root mysql password (no reset)

Is there a way to get back / retrieve a mysql root password. I mean get it back : not resetting it (I already know how to reset it and I use the reset method currently).
0
votes
2answers
68 views

Wrong syntax in sql

I have a table called sp_en and this table has 2 columns: "no" and "value". I want to change "value" of row with "no": 4433 to 1 so I enter the command below: INSERT INTO sp_en (Say) WHERE no='4433' ...
1
vote
1answer
2k views

Linux ports are blocked even when firewalld is disabled!

RHEL 7.4 I disabled the firewalld and also checked that SELINUX is disabled. But still when I use telnet to check the ports, port 3307 refused the connection. Even port 80 rejects the connection. ...
2
votes
0answers
427 views

MySQL Workbench and multi hop ssh tunnel

I have an issue with MySQL Workbench. This is how my connection looks like: laptop => bastion:22 => machineX:22 (10.10.10.10) => mysql:3306 So, I have two hops before I can reach the ...
1
vote
1answer
138 views

PhpMyadmin times out with small SQL file

I am trying to upload bump to phpmyadmin, which has has only 2MB but it has 12 thousand lines. I always get this error: Service Unavailable The server is temporarily unable to service your request ...
1
vote
1answer
330 views

apparmor: mysql permissions--with no recent changes

UPDATE: I now know my issue was database corruption, but discerning it was somewhat tricky--apparmor appeared to be the cause for longer than it should've. I didn't note when first posting that even ...
1
vote
0answers
38 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, because even the database couldn't save new rows. ...
2
votes
0answers
302 views

High Memory and Swap Usage but server running fast

Running a high traffic lemp web server on Centos 7 platform using nginx and mariadb. The server is running very nicely and load avg and cup usage is acceptable but from what I know it should not be. ...
1
vote
0answers
126 views

mysqladmin generates “error” messages

Some time ago I installed NGINX, php7, mariaDB and Wordpress on my Raspberry Pi running Raspbian. I created a Wordpress database - which is working. Recently I installed ssmtp and mailutils on my ...
0
votes
1answer
50 views

LAMP DB-agnostic way to create a DB stack

Is there a LAMP-MySQL (or equivalent) agnostic way to create a DB stack that includes: DB-user and a relative password DB with the same name as of the user Setting a host for the DB (say, localhost) ...
0
votes
0answers
30 views

How can i change mysql password. I tried it. But not work.?

First i login to my server using putty. and this is my server data uname -or 2.6.32-754.6.3.el6.x86_64 GNU/Linux uname -a Linux vps-xxx-xxx.example.com 2.6.32-754.6.3.el6.x86_64 #1 SMP Tue Oct 9 ...
0
votes
1answer
466 views

Slow response of server

I have a local development server in the local network. There are many instances of magento sites running there. Developers work a 5-6 different magento's and when there is such use the server ...
0
votes
0answers
8 views

a lack of DTrace probes of mysql@5.6 installed via brew under macOS

I installed mysql@5.6 via brew (brew install mysql@5.6) under my macOS, but when I run sudo dtrace -ln 'mysql*:::', comparing to Table 5.6 MySQL DTrace Probes there are only a few probes listed, sudo ...
0
votes
2answers
533 views

Error upgrading MySQL 5.5 to 5.6 CentOS 6.6

I wish to upgrade MySQL 5.5 to 5.6 on my CentOS 6.6 server and I am receiving an error after command yum update mysql as per the below output. I am following the guide here. I have also tried to ...
0
votes
2answers
97 views

I use `ps -ef` find a `mysqld` progress, but how can I know which conf file it using?

I use ps -ef find a mysqld progress, but how can I know which conf file it using? [root@controller data]# ps -ef | grep mysql mysql 8901 1 0 15:15 ? 00:00:00 /usr/sbin/mysqld root ...
1
vote
1answer
2k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is the ...
0
votes
1answer
42 views

Service mysqld 5.6 keeps starting and stopping on CentOS 6.9

On my VPS, mysqld starts and right after that, it automatically stops and then starts again automatically. I tried sudo service mysqld stop and it succeeded. After I started it manually and succeeded....
0
votes
1answer
337 views

htop - why does cpu% much higher than cpu core %?

So I have htop running on my RHEL 7.5 64-bit and noticed something I've not seen before. I have 4-core and it shows that the % used fluctuates but never over 95% for each one. However, when I look ...
2
votes
2answers
124 views

Why does the root user have control over mysql directories but not show as a member of the mysql group?

It seems somewhat similar to the question here but I think what I'm asking is a little different. I've got a CentOS 5.x box running with mysql on it. The root linux user can edit/modify files in /...
1
vote
0answers
932 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
0
votes
0answers
39 views

ionice vs nice for mysqlimport

I am trying to import a huge .sql file into a mysql server. What (if any) is a best option to speed up the process (all other parameters being equal) reducing the process niceness to -20? setting ...
3
votes
2answers
1k views

Error establishing a database connection; how can I determine whether or not these connections are real?

I've just run into a problem today with MySQL reaching its database connection capacity. The error I'm receiving is, Error establishing a database connection. When I try to access /phpma, I get this ...
2
votes
1answer
2k views

How to script a database migration using SSH?

I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a copy of the live database to our local development ...
0
votes
0answers
217 views

ownCloud with mariadb under docker-not avalable connection

I tried to use official documentation https://github.com/owncloud-docker/serverwith docker-compose. My .env file: OWNCLOUD_VERSION=10.0 OWNCLOUD_DOMAIN=localhost ADMIN_USERNAME=admin ADMIN_PASSWORD=...
3
votes
1answer
2k views

Installing mysql with mysql-apt-config: missing keys

I'm trying to update mysql on my Debian server with mysq-apt-config, but whenever I try to update it with dpkg -i mysql-apt-config_0.8.11-1_all.deb I get a missing keys error. > dpkg -i /tmp/mysql-...