Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

0
votes
0answers
8 views

problem with changing the strength of password in mysql

I have installed mysql server and while making mysql secue installation i have set the password level to strong password .so i created the password with some characters like . ,and @ while installing ...
-1
votes
0answers
19 views

Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

I am not able to run php artisan migrate command in laravel 5.7, mysql 5.7 and Ubuntu 18.04. I get Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' ...
0
votes
0answers
39 views

Unable to install mysql-server: Sub-process /usr/bin/dpkg returned an error code (1)

I am trying to install MySQL on my Ubuntu but getting the following error. I tried some of the solutions available on this website and on the internet, but none of it seems to work. $ sudo apt-get ...
0
votes
1answer
55 views

Ubuntu 18.04 failed to boot: Faile to start MySQL Community Server

I am facing serious issue. My hard disk was extremely full that 0 bytes available. I tried to empty the trash bin but it hanged. I restarted the system. But it failed. It gives this messages: [FAILED]...
1
vote
1answer
60 views

mysql fails to install on ubuntu 18.10

I can't install mysql on Ubuntu 18.04 or 18.10. I had this issue after upgrading from 16.04 to 18.04. After no luck getting it to work in separation I upgraded to 18.10 No luck, It just won't ...
0
votes
1answer
15 views

Ubuntu 14.04.5 x64 - Perforce Helix and LAMP Server?

Hello im currently using an Ubuntu 14.04.5 x64 hosted online only for for versioning Unreal Engine 4 projects. I installed via terminal (Putty) the Helix Visual Client (P4V) also known as Perforce for ...
0
votes
0answers
18 views

Install appropriate client for mysql-server 8.0

A Windows machine has localhost mysql 8.0.13 server. I have installed the ubuntu package for windows. In ubuntu mysql-client and mysql-client-core are version 5.7 they are not fully compatible and ...
-1
votes
1answer
14 views

Moving mysql data from one database to another (slightly different) database

I took an open source product (applicant tracking system) and forked the code, and had some extra features added, which amounted to some extra tables in the MySQL database. Now, I would like to load ...
0
votes
0answers
47 views

Command 'mysqld' not found, but can be installed with:

Mysql service in running, and think work correct. But i can't run from ubuntu console. When i write root:/ mysql Console answer me: Command 'mysqld' not found, but can be installed with: sudo apt ...
0
votes
0answers
46 views

Problem installing mysql - “Can't read dir of '/etc/mysql/conf.d/'”

hello i try to install mysql on ubuntu 16.04 but get this error message ES1-431:~$ sudo apt-get install mysql-server Leyendo lista de paquetes... Hecho Creando árbol de dependencias Leyendo la ...
1
vote
1answer
105 views

mysql 5.7 is working slow on ubuntu 18.04 LTS

I am currently using ubuntu 18.04 server ( with 8GB RAM , 100 GB HDD & Intel I3 processor ) for project deployment, & am using mysql 5.7 database server , but whenever I tries to insert data ...
0
votes
1answer
44 views

mysql connect to remote database

I wish to modify data on my website database and thought I could do it from the command line but it keeps failing. For example:- website is myweb.co.uk database is mydb port 22 mysql -u myweb -...
0
votes
1answer
59 views

“ Uncaught Error: Call to undefined function mysqli_connect()”

I'm using mysql Server version: 5.7.24-0ubuntu0.18.04.1 (Ubuntu), trying to do a simple connection to the database but whenever I try to connect to the database, I get this error. 127.0.0.1:34236 [...
0
votes
1answer
98 views

Failed to start mysql.service: Unit mysql.service not found [duplicate]

Today Xampp suddenly stopped working. When I try to start xampp, then mysql is not running: After browsing for this issue, I found that sudo service mysql start should solve it. However, this ...
0
votes
1answer
50 views

Facing issue with MySQL slowness while inserting data with Ubuntu 18.04 LTS

I have installed all the supported MySQL 5.7.X versions on Ubuntu 18.04 but facing issue while inserting data. Same MySQL versions 5.7.X are installed on Ubuntu 16, it is working fine. No ...
0
votes
0answers
15 views

mysql disable login with blank password [duplicate]

I have created a Ubuntu 18.01 droplet on digital ocean. while creating droplet I opted for one click LAMP installation. Therefore I got mysql pre-installed. Now I am able to login as root by using a ...
0
votes
0answers
12 views

MySQL start failed in Ubuntu after trying various methods to recover my data

BACKGROUND So last week I switched from Windows to Ubuntu 18.04 and I was working on an Android app during that so I had to backup my backend including the database, and (foolish of me) I did not ...
0
votes
4answers
86 views

How to fully remove MySQL and phpMyAdmin

I am sorry if this has been posted before. I have been learning the use of MySQL and phpMyAdmin. Having followed an installation guide during an instructional course, I installed the above ...
0
votes
1answer
57 views

Problem with my bash script or crontab

My LAMP installation on Ubuntu 18.04 LTS is working fine. But sometimes when MySQL is down it doesn't gets restarted automatically. So i google around and found below the bash script which checks ...
0
votes
0answers
37 views

Wordpress cant connect to my database

I get to the point where i have to configure my wordpress and by that the database to which it should connect to. here is how i created the database in mysql: mysql>create database `wplocal`; ...
0
votes
0answers
62 views

DataGrip MySQL connection: user/password combination is rejected

In DataGrip, I have this error when I try to test the connection to my local MariaDB instance: The specified database user/password combination is rejected: [28000][1045] Access denied for ...
0
votes
1answer
146 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) [duplicate]

While entering MySQL server I am getting an error like this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) What's the problem and how can ...
0
votes
0answers
13 views

Problem in Ubuntu OS version 18.04 LTS for JAVA( version-6 ICEDTEA ) application modules sub manu is not dispaly after mouse-hoover

I have faced Mouse hover issues for Java application, after Ubuntu version 18.04 LTS up-gradation used java version ICEDTEA-6, MySql server 5.7v & My application sub-menu is not display. My ...
0
votes
0answers
25 views

OpenLDAP with MySQL backend

I'm trying to set up OpenLDAP to use MySQL database for a user database. I already have postfix set up on the same server and all the postfix users exist in the MySQL database. So now I need to set ...
-3
votes
1answer
45 views

Getting the plain text code while i am accessing the phpMyadmin in Ubuntu [duplicate]

<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Main loader script * * @package PhpMyAdmin */ use PMA\libraries\RecentFavoriteTable; /** * Gets some core libraries and displays a top ...
0
votes
2answers
39 views

How to install mysql V8 in ubuntu 16.04?

I am following this tutorial in order to install MySql version 8.x in my Ubuntu 16.04. Before the second step I should have the prompt asking me which version I wish to configure with mysql 8-0 in ...
0
votes
0answers
192 views

mysql cant install on ubuntu 18.04 becasue it cant create directory /var/lib/mysql that it just created

I upgraded to 18.04 from 16.04 and mysql instal failed. The error I am getting is it can't create a directory /var/lib/mysql which was there, and if I remove it the install process re-creates this ...
0
votes
2answers
135 views

Unable to install mysql with Can't read dir of '/etc/mysql/conf.d/' error

I just installed the latest version of ubuntu on usb. First I run sudo apt update, then sudo apt install apache2. So far everything was fine. But when I run sudo apt install mysql-server I get this ...
0
votes
0answers
63 views

Remove Mariadb 10.3 and Mysql completely from Ubuntu

I have been trying to remove all the package. apt-get remove --purge mysql* apt-get remove --purge mysql apt-get remove --purge mariadb apt-get remove --purge mariadb* apt-get --purge remove mariadb-...
0
votes
0answers
27 views

Disk full but I don't install anythink

enter image description here That are new Ubuntu 18 VPS and I only put Apache2, MySQL, phpmyadmin, java and minecraft server (~4-5GB) The last action I do is purge java 11, because it cause problem ...
0
votes
1answer
99 views

MySQL 5.7 server can't be reinstalled

After problems with MySQL server that couldn't finish an update properly (5.7.24). I followed this answer. So basically, I can come back in a "stable" state when after running the following commands: ...
0
votes
0answers
82 views

MySQL: Access denied to 'root'@'localhost' (using password: YES)

I am implementing a virtual LTE EPC setup which requires a mysql database for one of its modules (HSS). After creating that, I had to run that module but receive the error as shown:
0
votes
0answers
30 views

Enter Password for root while installing mysql

I am Installing MySQL on ubuntu I entered the commands sudo apt-get update sudo apt-get install mysql-server When i entered the command: mysql_secure_installation It asked me for root password i ...
1
vote
0answers
37 views

Ubuntu Server requires service restart every few days

I'm new here and I hope you can help me out this time. I have a MySQL server which receives many requests from my other servers...daily up to 1000 requests (HTTP and remote MySQL). However, for some ...
0
votes
0answers
36 views

MySQL is hosed in 18.10

I just ran across a new problem with MySQL in 18.10. As far as I know, it was running fine after the 18.10 upgrade. Now, when I shutdown the system, it pauses trying to shutdown MySQL with a 10 ...
0
votes
0answers
19 views

why is my MySQL inactive?

I first installed xampp on linux. why is my MySQL database inactive, I have restarted, but it's still not active ... when I go to http: // localhost / phpmyadmin / an error appears like the following ...
0
votes
1answer
54 views

I have problem with this error while reinstall mysql

Reading package lists... Done Building dependency tree Reading state information... Done Suggested packages: mailx tinyca The following NEW packages will be installed: mysql-server-5.7 0 ...
0
votes
0answers
31 views

MySql Server trouble. Won't start without innodb_force_recovery = 3 line in mysqld.cnf

With the innodb_force_recovery = 3 line in mysqld.cnf the server starts but then some of the tables won't update. Some work fine but I don't know the difference. When that line is commented out the ...
0
votes
0answers
28 views

mysql command changed to mysqli command after update is not working

SUM(Pages) is not working like it was working in older version Old Code: $newuresultp = mysql_query("SELECT *, SUM(Pages) FROM tpages WHERE File like '%$ck%'"); New Code: $newuresultp = ...
1
vote
1answer
53 views

mysql8 won't start

In terminal I do: sudo service mysql start and I get: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for ...
0
votes
0answers
30 views

Unable to insert in table in database in mysql using php

I am using ubuntu 18.04 and has used mysql-server-5.7 and phpmyadmin. I am unable to login to root and hence so we have created one user with password. I am able to read data from the mysql database. ...
0
votes
1answer
25 views

How to install mysql server [duplicate]

When I try to download something, I use sudo apt-get install/upgrade <package> However, this gives me error messages: W: Some index files failed to download. They have been ignored, or old ...
2
votes
1answer
47 views

“cd /ect/mysql/” gives error “-bash: cd /ect/mysql : No such file or directory” when it exists

I recently started an EC2 AWS Linux server instance with Ubuntu 14.04. I am very new to ubuntu and launching websites on servers, but here is (in short) what I have done so far. I successfully ...
1
vote
1answer
39 views

how to fix mysql installation if I accidentally delete some file of mysql package

I accidentally delete /etc/mysql (and other files), Now every time I try to install a new package, apt will fail. Then I try to fix it with: sudo apt --fix-broken install but it will fail with ...
0
votes
1answer
78 views

php7.2 and PDO - 'could not find driver'

first of all: System Ubuntu 16.04 Apache2 PHP 7.2 DB: MYSQL now following problem: I have two projects the first project is just a php file with the following code <?php $servername ='localhost'; ...
0
votes
1answer
24 views

i have installed xampp on ubuntu 18.04 .. but why is an error like this?

I'm a beginner. I have installed Xampp on ubuntu 18.04. Apache web server and proFTPD are running and the lights are green why can't mysql run ?? I clicked Start, but it still hasn't run
0
votes
0answers
25 views

docker unable to import mysql script with JSON column

In the docker container While importing .sql file into MYSQL database we are getting below error: ERROR 1064 (42000) at line 162: You have an error in your SQL syntax; check the manual that ...
0
votes
0answers
39 views

Recovering wordpress blog from 16.04 LTS

One of my servers running Ubuntu 16.04 (64bit) failed to start due to some bad blocks in the hard disk. Some how I could copy the data. I was running a wordpress blog on this server. Now how can I ...
1
vote
0answers
60 views

MySQL database suddenly stopped working “control process exited”

This is not the same as the linked question. This has been working for years, and is still installed I'm not so experienced with Ubuntu. But I had a server running a MySQL database for a client of ...
2
votes
2answers
141 views

MySQL 5.7 upgrade won't complete

APT isn't able to upgrade mySQL for me. I believe the 1045 error is due to login details. I'm able to run mysql_upgrade -uroot -p and finish it manually but how do I tell apt that it's done, please ...