badbook.blogg.se - How to setup kodi on mac

$sudo apt-get install mysql-server to install MYSQL Server.$sudo apt-get update & sudo apt-get dist-upgrade to ensure that you have the very latest iteration of Raspbian.Enter your MySQL root password as set above, or just press enter if you didn't set one to log in with a blank password.Get into the MySQL command line utility: $mysql -u root -p.Recommended - Set your MySQL root password with /usr/bin/mysqladmin -u root password 'new-password'.Note: Alternatively you can leave this file as is to allow local and remote access.

To configure MySQL to listen for connections only from network hosts, edit /etc/mysql/my.cnf and add the bind-address directive to the server's IP address:.

RedHat based Linux (RHEL, CentOS, Fedora):

Close out the command line tool with \q.

Type in: flush privileges and press return.

Type in: GRANT ALL ON *.* TO 'kodi' and press return.

Type in: CREATE USER 'kodi' IDENTIFIED WITH mysql_native_password BY 'kodi123#' and press return Using the following command should avoid errors. Note: When using MySQL8 or higher, there are additional password requirements and new authentication methods.

Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi' and press return.Get into the MySQL command line utility: mysql -u root -p.default_authentication_plugin=mysql_native_password.When using MySQL8 or higher (Ubuntu 20.04 or later), add the following line at the end of /etc/mysql//mysqld.cnf:.

from both the MySQL host to itself and also from other clients), either comment out the bind-address using a hash (#) to disable it, or use bind-address = 0.0.0.0 to open it completely.

Note: To allow both local and remote access (i.e.

Note: Replace 192.168.0.5 with the appropriate address.

To configure MySQL to listen for connections from network hosts, edit /etc/mysql//mysqld.cnf and change the bind-address directive to the server's IP address:.

$sudo apt-get install mysql-server (see also: ).