MariaDB > GRANT ALL PRIVILEGES ON gogs.* TO IDENTIFIED BY ' strongpassword' ĭon’t forget to replace ‘ strongpassword‘ with an actual strong password. Log in to the MariaDB console with the MariaDB root user, using the password that you have set up in the previous step: mysql -u root -pĬreate a MariaDB database and user for Gogs, and grant permissions to the user using the following commands: MariaDB > CREATE SCHEMA `gogs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Remove test database and access to it? YĪll done! If you've completed all of the above steps, your MariaDB If the program asks for a MySQL root password before you have set it, press the key, as the default root password is blank by default: Set root password? Y Then, answer the security questions as follows. This part is optional, but strongly recommended as it improves the security of your database server: sudo mysql_secure_installation When the MariaDB installation is complete, secure your MariaDB server using the mysql_secure_installation script. To install the latest MariaDB server execute the following command: sudo yum install mariadb-server Gogs can use MySQL/MariaDB, PostgreSQL, MSSQL, TiDB, and SQLite3 databases as a database backend. You can do that by using the following command: sudo yum install git Step 2: Create a MariaDB database Once logged in, run the following commands to update all packages to their latest available versions: sudo yum update Replace IP_Address and Port_Number with your server’s respective IP address and SSH port number. Log in to your VPS via SSH as the root account or as a sudo user: ssh IP_Address -p Port_Number A user account with sudo privileges, or access to the ‘root’ user itself.
0 kommentar(er)
