Resetting root password for recent Debian versions Now you can access the server simply by running In the client, execute one of the following (replace YOUR_SYSTEM_USER with your user name):ĬREATE USER IDENTIFIED WITH auth_socket įor the MariaDB 5.2.0+ unix_socket plugin: To allow your user to access the MySQL server, run the MySQL client as root: Note: Your user must be in the sudo group for this to work. That is, after installing mysql-server and mysql-client you can access the server with root privileges by executing the following If you have Apache and PHP installed, you can use phpMyAdmin to administer any MySql databases.Īt least since Debian 9 "stretch" operating system credentials are used by MySQL Server to authenticate users. You can also use tora, emma and gmysqlcc GUI clients to access and administrate MySQL databases. This is the "official" GUI of the MySQL project and can be installed from the main repository by running the following command in a terminal: MySQL Workbench is also a great GUI tool for managing local and remote databases. To use MySql client just type as any user : mysql The Debian package of MySql server creates the user debian-sys-maint that is used in the start-stop and cron scripts.
0 kommentar(er)
