Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,943
questions
3
votes
2
answers
8k
views
Why is the mysql-server package from mysql.com missing server files?
I'm usually not using Ubuntu, but decided to give it a try today because it's the preferred distro for Windows Subsystem for Linux, that I wanted to try today to see if/how it could replace my VMWare ...
35
votes
4
answers
69k
views
Start MySQL on Startup
I installed MySQL, and changed the configuration so the databases are stored on a separate hard drive. In the process MySQL has stopped starting up automatically. When I start the computer, I need to ...
0
votes
2
answers
6k
views
Ubuntu 22.04 -- phpmyadmin error: mysqli extension missing
I can't get phpmyadmin to run, it reports The mysqli extension is missing. I have been running MySQL using MariaDB for a while, through multiple versions of Ubuntu. Currently running 22.04. After ...
8
votes
7
answers
80k
views
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
The connection to the controluser as defined in your configuration has failed..
1
vote
1
answer
7k
views
I Get 'Import error : No module named MYSQLdb' in python 2.7. I've tried everything from the other similar thread
The error:
import MySQLdb
ImportError: No module named MySQLdb.
Particulars:
OS is Ubuntu 14.04
python 2.7.10 and is the default
MySQL 5.5.43
What I've tired:
sudo apt-get install build-...
0
votes
1
answer
5k
views
Access denied when using mysqli with php
I want to connect to my database on my Linux machine with PHP (PHP 7.2.24-0ubuntu0.18.04.6 (cli)) using mysqli(). But whenever I try to access it, I get this error:
Warning: mysqli_connect(): (HY000/...
0
votes
4
answers
10k
views
php my admin showing php code instead of login
hello i know there are a lot of questions talking about this problem but the thing is i installed apache2 and mysql and php 7.3 but when i try to enter localhost/phpmyadmin it shows
?php
/* vim: set ...
0
votes
1
answer
5k
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 [...
2
votes
1
answer
12k
views
Error MySQL: ERROR 2002 (HY000): Can't connect to local MySQL server through socket (Ubuntu 14.04.5)
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
service mysql status
mysql stop/waiting
service mysql restart
stop: Unknown instance:
...
0
votes
0
answers
180
views
After apt install: Transport endpoint is not connected
I run apt install mysql-server to install mysql, but it stuck (cursor blinking, no output), so I cancelled it with Ctrl+C.
After that, every command returned "Transport endpoint is not connected&...
-1
votes
1
answer
56
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 ...
2
votes
1
answer
5k
views
MySQL hogging memory
I have an Ubuntu 18.04 server running mysql 5.7 and a handful of webapps. Mysql is using significant memory and forcing swap usage. We've had a few fatal crashes from high memory usage. I'm working on ...
1
vote
1
answer
4k
views
XAMPP MySQL and phpMyAdmin error Ubuntu 14.04
Just installed latest xampp package on my localhost and on my terminal everything looks fine as shown below:
root@SKYBUNTU:/home/maze# /opt/lampp/lampp start
Starting XAMPP for Linux 5.6.3-0...
XAMPP:...
0
votes
1
answer
167
views
Missing service - mysql: unrecognised service
I'm running Ubuntu 20.04.6 on WSL, and am having trouble starting mysql-server using the command sudo service mysql start, which returns mysqld: unrecognized service (the same result with mysqld).
For ...
3
votes
2
answers
7k
views
XAMPP: Starting MySQL...already running?
When I start XAMPP it shows this
Starting XAMPP for Linux 7.0.8-0...
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...already running.
XAMPP: Starting ProFTPD...ok.
when i open localhost/...
0
votes
1
answer
131
views
Permission issue while installing latest mysql server after upgrade from 18.04 to 22.04
I cant install the latest mysql server on my local machine. Everything was working fine before the upgrade (nginx/phpmyadmin etc) but it seems like it removed some things during that (perhaps I ...
2
votes
2
answers
1k
views
Is it possible to install MySQL 5.5.45 on Ubuntu 22.04?
I need to install MySQL 5.5.45 on Ubuntu 22.04. I was provided with legacy code using PHP 5.4.60 and MySQL 5.5.45. I didn't have any issues with installing PHP 5.4.60. But I'm not able to install ...
0
votes
0
answers
47
views
Why is that when I am inserting a USB, Ubuntu gives me a signal that it is inserted, but it doesn't show up on the taskbar, but appears in disks?
I am using a Dell Vostro 3590, Ubuntu Linux version 23.10. However, I am unable to install MySQL community server, MySQL connector which I require for a project I am working on. I tried installing ...
1
vote
1
answer
7k
views
E: Package 'mysql-server' has no installation candidate
apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not available, but is referred to by another ...
1
vote
1
answer
1k
views
NO_PUBKEY and Some of The File Has an Unsupported Filetype
When I do a command "sudo apt update" on Ubuntu 22.04.3, always occure this error :
W: https://dl.google.com/linux/chrome/deb/dists/stable/InRelease: The key(s) in the keyring /etc/apt/...
0
votes
3
answers
6k
views
Issue with installation of MYSQL server/client on UBUNTU 22.04 LTS(Jammy)
I am trying to install mysql server on my Ubuntu 22.04 LTS but couldnt do that it says unmet dependencies and i tried installing the required dependencies but it didnt work.
sudo apt install mysql-...
2
votes
2
answers
2k
views
"The requested URL was not found on this server." When runnnig a Contao website on Ubuntu 20.04.6 LTS?
I've received a website that uses the Contao 3.4.50 CMS with my mission being slowly upgrading it to the newest version but first I need to get the entire website working on my localhost.
I am using:
...
2
votes
1
answer
1k
views
Configuring MySQL for SLURM
I'm having problems getting SLURM (for job scheduling) to work with a MySQL database. I was using this as a reference, but perhaps I misunderstood something in it. If someone can let me know what I'...
0
votes
1
answer
253
views
Can't connect to local MySQL server on Ubuntu 22.04
I have been tried many ways to install WordPress in my Ubuntu 22.04. However, I always receive errors.
This is about MySQL information:
alireza@OptiPlex-5090:~$ mysql --version
mysql Ver 15.1 Distrib ...
13
votes
1
answer
12k
views
How to fix apt update after to upgrade the mysql.list file? [duplicate]
After to did do an upgrade through VirtualBox for Ubuntu Desktop 20.04 to 22.04 - focal to jammy - at the /etc/apt/sources.list.d directory exists the mysql.list file.
According with a research was ...
2
votes
1
answer
4k
views
Impossible to install MySQL 5.7 on Ubuntu 20.04
This is what I've done so far on a fresh Ububntu 20.04 installation:
wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb
In the prompt, I ...
0
votes
1
answer
5k
views
MySQL Workbench 8.0 - Error 1142 & Error Code: 1370
I have created a user 'user1'@'localhost'.
then granted all privileges to the user1 with grant option. any help?
then I go and make a connection of user1 to the database and it keeps throwing error ...
4
votes
2
answers
6k
views
MariaDB killed by OOM Killer every couple days
my MariaDB server is being killed every couple days.
× mariadb.service - MariaDB 10.6.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: ...
1
vote
2
answers
5k
views
mysql-Workbench can't connect to server
In workbench the status of the server is STOPPED and the startup log message:
2016-05-28 11:14:37 - Checking server status...
2016-05-28 11:14:37 - Trying to connect to MySQL...
2016-05-28 11:14:37 - ...
0
votes
2
answers
1k
views
Problems installing MS SQL Server and MySQL on Ubuntu 22.04
I wanted to download and install the SQL server and MySQL to execute my queries in Ubuntu Linux 22.04. I faced many problems but now I was stuck in the major issue. When I run
dpkg -l | grep -i mysql
...
0
votes
1
answer
52
views
Ubuntu Server showing white blank phpMyAdmin
My VM Ubuntu Server returning white blank phpMyAdmin
I used this for installing my phpMyAdmin:
sudo su
sudo apt install unzip
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-...
1
vote
1
answer
376
views
Not getting the login page after installing the phpMyAdmin
I have tried so many times but still, I am getting a blank screen while accessing the phpMyAdmin page. I have checked on google but haven't found the solution.
I have deleted the PHP, MySQL and ...
1
vote
2
answers
4k
views
phpmyadmin showing error regarding mysqli, but its already installed
first screen shot of error showing phpmyadmin error
second screen shot after using sudo with mysqli
1
vote
1
answer
6k
views
2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "Internal error/check (Not system error)"
I have these users in MySQL
User
Host
debian-sys-maint
localhost
mysql.session
localhost
mysql.sys
localhost
root
localhost
I want to connect to it remotely from my mac via SSH
I can't connect. ...
2
votes
2
answers
10k
views
Can't start mysql after upgrade
OK this is driving me mad. Ubuntu 20.04.5 LTS (on WSL)
I am assuming that it crashed, then upgraded mysql, and now it won't start:
2022-08-31T16:37:29.463168Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is ...
1
vote
1
answer
7k
views
PHPMyAdmin - How to fix #1006 - Can't create database 'database_name' (errno: 13 "permission denied") in Ubuntu 20.04?
In my Ubuntu 20.04 (Desktop/Laptop not server) OS based machine I recently install XAMPP (Version: 7.4.7).
Now when I try to create a database it shows #1006 - Can't create database 'database_name' (...
0
votes
1
answer
4k
views
Why database that created in phpmyadmin won't show in workbench?
I just installed LAMP today. I created a database also a tables in phpmyadmin.. But when checking this in MySql Workbench it doesn't show the database? Any one knows came up with these problem?
0
votes
3
answers
5k
views
MariaDB bind-address not updating?
I'm trying to set the bind-address of my MariaDB installation to 0.0.0.0 to allow external connections.
I edited /etc/mysql/mysql.conf.d/mysqld.cnf and updated the [mysqld] section to the following:
...
0
votes
1
answer
6k
views
MariaDB installation error: Unable to correct problems, you have held broken packages
I am trying to install MariaDB following the official site but I keep getting errors.
First step:
$ sudo apt-get install software-properties-common
Reading package lists... Done
Building dependency ...
0
votes
1
answer
192
views
Test -s is failing
Help,
I am running Ubuntu 23.10 Server and trying to write a script to back up my server. As the script runs it should create an archive and then check for the archive's existence. The relevant code ...
0
votes
0
answers
46
views
MySQL Install error
I'm a new Linux user.
I've tried to install MySQL, but every time i try to install it, I get the same error.
I executed sudo apt install mysql-server, and got:
ERROR: Database files are locked. Daemon ...
1
vote
1
answer
144
views
Multiple binlogs in /var/lib/mysql folder
Recently I did a website and server migration. It was working fine in the beginning, but recently I found that server has consumed 100% of the storage and there are multiple bin files in /var/lib/...
1
vote
1
answer
2k
views
Why does Ubuntu prohibit installing both MySQL and MariaDB via Apt?
Something I've seen stump users (including myself) is that Apt won't allow both MySQL and MariaDB to be installed. For instance, here's a nearly 3-year-old AskUbuntu question on the topic, still ...
0
votes
0
answers
62
views
MySQL SQLSTATE root and normal login not function
Hello guys i have little problem with MySQL and Pterodactyl. When i try add databases i got this problem.
There was an error while trying to connect to the host or while executing a query: "...
3
votes
6
answers
33k
views
How to log in to MySQL shell when the user has no password?
I got this error:
root@sys3026:/home/sys3026# mysql --user=root --password
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Any one please ...
2
votes
1
answer
474
views
MySQL not allowing 'root@localhost' to access it
I'm trying to set up MySQL server as part of a LAMP stack on Ubuntu Server 22.04, I have installed MySQL and whenever I try to run the commands:
~$ sudo mysql
or
~$ sudo mysql -u root -p
It returns ...
5
votes
2
answers
11k
views
Install of mysql-server after mariadb fails
Using Kubuntu 17.04. I tried to install mariadb, which did not work, so now I am trying to revert back to mysql. However when I try to install mysql it is not working anymore either:
~# apt-get ...
0
votes
1
answer
148
views
Not installing softwares after changing the server [duplicate]
I changed the download server from sri lanka server to US server using software and update window. Then I tried to install mysql using this command.
sudo apt-get update
sudo apt-get install mysql-...
4
votes
7
answers
96k
views
How fix permanently: Job for mysql.service failed because the control process exited with error code
I am working with Ubuntu 18.04 and MySQL Server - 8.0.18
Suddenly today MySQL can't start anymore
With the sudo service mysql status command appears:
sudo service mysql status
● mysql.service - ...
0
votes
0
answers
37
views
How do I connect mysql to phpmyadmin via devlibox?
I don't know if the term "connect" will be the right term, but I cannot figure out anything else.
So I started using devilbox in Ubuntu 22.04 and when I tried running this code:
<?php
$...