With the new changes in the new version of Deepin 15.7 some problems have arisen which Deepin is already solving and others that are not yet due to the update of libraries. In this post I will explain how to install the database manager MySQL Workbench right from the start.
requirements
- Have installed Deepines
Installation
First we installed MySql Server but version 5.6, since version 5.7 has given me problems with the password issue and entering the server.
sudo apt install mysql-server-5.6
If you already have version 5.7 installed, transfer your databases to a .sql file so as not to lose them, then execute the following:
sudo apt-get --purge remove mysql-client mysql-server mysql-common sudo apt-get autoremove sudo rm -rf / etc / mysql /
They put their password that they will use for MySql Server and to verify, they connect:
mysql -h localhost -u root -p
Now for the change of base that Deepin had (it no longer incorporates the dependency (gdal-abi
), we will install the latest version that is available in our Deepines repository.
sudo apt update sudo apt install mysql-workbench-community
Now we open the program to verify the installation.
If you get a message that the program was compiled for Ubuntu, you are given in not showing again. The program works correctly.
Checking the correct installation, we can continue using this database manager in Deepin 15.7.
credits
The solution was given by @[user_display id=»17″] and tested for@[user_display id=»10″].
Follow the steps and have this mistake:
With
mysql --version
you will see what version of mysql you havedebes asegurarte que sea 5.6, ya que la 5.7 da un poco de lios
por el tema del password
si tu versión si es 5.6, fuerza el inicio de mysql
service mysql start
Hi! I couldn't install the mysql workbench the way you guys did. It tells me that it is not found. I was able to install 8 from the official page but I don't know how to get the server up
The server is 5.6?
but use
then
and you can then use phpmyadmin to manage your bd,
only before entering phpmyadmin you must execute
A mi también me dice «No se ha podido localizar el paquete mysql-workbench-community». Tengo MariaDB «mysql Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2»
Hello, I also had trouble with mysql 5.7 regarding the root pass and I solved it like this
entre como root con sudo su
entre a mysql
y ejecutè el siguiente comando
use mysql
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY «clave»;
FLUSH PRIVILEGES;
exit
reinicio y a probar