Comments - Reinstall Mysql database with too manny errosr...

3 years, 3 months ago Telefon Apuka

I'm remove all folders with mysql and reinstall all. in momment of securize mysql install have this error...

ubuntu@ubuntu:/var/www/html/blog$ sudo mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

How to correct this ?

 
3 years, 3 months ago Ian Gilfillan

This looks like the version of mysql_secure_installation included with MySQL, not with MariaDB.

 
3 years, 3 months ago Telefon Apuka

sudo apt install mariadb-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libevent-core-2.1-7 libevent-pthreads-2.1-7 libmecab2 libprotobuf-lite23 linux-headers-5.8.0-1016-raspi linux-image-5.8.0-1016-raspi linux-modules-5.8.0-1016-raspi linux-raspi-headers-5.8.0-1016 mecab-ipadic mecab-ipadic-utf8 mecab-utils Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: mariadb-client-10.3 mariadb-client-core-10.3 mariadb-server-10.3 mariadb-server-core-10.3 Suggested packages: mailx mariadb-test tinyca The following packages will be REMOVED: mysql-client-8.0 mysql-client-core-8.0 mysql-server mysql-server-8.0 mysql-server-core-8.0 The following NEW packages will be installed: mariadb-client-10.3 mariadb-client-core-10.3 mariadb-server mariadb-server-10.3 mariadb-server-core-10.3 0 upgraded, 5 newly installed, 5 to remove and 0 not upgraded. Need to get 0 B/15.8 MB of archives. After this operation, 81.4 MB disk space will be freed. Do you want to continue? [Y/n] y Preconfiguring packages ... dpkg: warning: files list file for package 'mysql-common' missing; assuming package has no files currently installed (Reading database ... 195980 files and directories currently installed.) Removing mysql-server (8.0.23-0ubuntu0.20.10.1) ... Removing mysql-server-8.0 (8.0.23-0ubuntu0.20.10.1) ... Failed to stop mysql.service: Unit mysql.service not loaded. invoke-rc.d: initscript mysql, action "stop" failed. dpkg: error processing package mysql-server-8.0 (--remove): installed mysql-server-8.0 package pre-removal script subprocess returned error exit status 1 dpkg: too many errors, stopping Failed to stop mysql.service: Unit mysql.service not loaded. invoke-rc.d: initscript mysql, action "stop" failed. Failed to preset unit: File mysql.service: Link has been severed /usr/bin/deb-systemd-helper: error: systemctl preset failed on mysql.service: No such file or directory Failed to start mysql.service: Unit mysql.service not found. invoke-rc.d: initscript mysql, action "start" failed. Unit mysql.service could not be found. dpkg: error while cleaning up: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 Errors were encountered while processing: mysql-server-8.0 Processing was halted because there were too many errors. E: Sub-process /usr/bin/dpkg returned an error code (1) ubuntu@ubuntu:$

 
2 years, 10 months ago Kaustubh Bhavsar

Hey do you solve this problem I also get same problem....

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.