![]() Try to access the database console as test_user: $ mysql -u test_user -p GRANT ALL PRIVILEGES ON test_db.* TO PRIVILEGES CREATE USER IDENTIFIED BY "Jek1oleiboafei4eeghu" Type '\c' to clear the current input statement.Ĭreate a Test database and user. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.26 MySQL Community Server - GPLĬopyright (c) 2000, 2021, Oracle and/or its affiliates. Login as root user with a created password: $ mysql -u root -p Let’s test to confirm if MySQL 8.0 installed on Debian 11/10 /9 is working as expected. Step 3: Test MySQL 8.0 Installation on Debian 11/10/9 Process: 26431 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)Īug 22 00:29:43 debian-bullseye-01 systemd: Starting MySQL Community Server.Īug 22 00:29:43 debian-bullseye-01 su: (to mysql) root on noneĪug 22 00:29:43 debian-bullseye-01 su: pam_unix(su-l:session): session opened for user mysql(uid=108) by (uid=0)Īug 22 00:29:53 debian-bullseye-01 systemd: Started MySQL Community Server. Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (running) since Sun 00:29:53 UTC 43s ago The mysql service should be started by default, you can confirm service status using the command: $ systemctl status mysql Select the Authentication plugin and select to finish installation of MySQL 8.0 on Debian 11/10 /9.Ĭheck version installed using the apt-policycommand: $ apt policy mysql-server When asked for the rootpassword, provide the password. Once the repository has been added, install MySQL 8.0 on Debian 11/10/9 by running the following commands: sudo apt update Step 2: Install MySQL 8.0 on Debian 11/10/9 Then tab to and press key to confirm version installation. Sudo dpkg -i mysql-apt-config_0.8.22-1_all.debĬonfirm addition of MySQL 8.0 repository as default when prompted. sudo apt update
0 Comments
Leave a Reply. |