Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
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 $...

1
2
3 4 5
59