Skip to content

Latest commit

 

History

History
74 lines (46 loc) · 3.14 KB

install-and-run-mysql-on-opensuse-vm.md

File metadata and controls

74 lines (46 loc) · 3.14 KB

  1. To escalate privileges, type:

     sudo -s

    Enter your password.

  2. To install MySQL Community Server edition, type:

     zypper install mysql-community-server

    Wait while MySQL downloads and installs.

  3. To set MySQL to start when the system boots, type:

     insserv mysql

  4. Start the MySQL daemon (mysqld) manually with this command:

     rcmysql start

    To check the status of the MySQL daemon, type:

     rcmysql status

    To stop the MySQL daemon, type:

     rcmysql stop

    [!IMPORTANT] After installation, the MySQL root password is empty by default. We recommended that you run mysql_secure_installation, a script that helps secure MySQL. The script prompts you to change the MySQL root password, remove anonymous user accounts, disable remote root logins, remove test databases, and reload the privileges table. We recommended that you answer yes to all of these options and change the root password.

  5. Type this to run the script MySQL installation script:

     mysql_secure_installation

  6. Log in to MySQL:

     mysql -u root -p

    Enter the MySQL root password (which you changed in the previous step) and you'll be presented with a prompt where you can issue SQL statements to interact with the database.

  7. To create a new MySQL user, run the following at the mysql> prompt:

     CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY 'password';

    Note, the semi-colons (;) at the end of the lines are crucial for ending the commands.

  8. To create a database and grant the mysqluser user permissions on it, issue the following commands:

     CREATE DATABASE testdatabase;
 GRANT ALL ON testdatabase.* TO 'mysqluser'@'localhost' IDENTIFIED BY 'password';

    Note that database user names and passwords are only used by scripts connecting to the database. Database user account names do not necessarily represent actual user accounts on the system.

  9. To log in from another computer, type:

     GRANT ALL ON testdatabase.* TO 'mysqluser'@'<ip-address>' IDENTIFIED BY 'password';

    where ip-address is the IP address of the computer from which you will connect to MySQL.

  10. To exit the MySQL database administration utility, type:

    quit

Add an endpoint

  1. After MySQL is installed, you'll need to configure an endpoint to access MySQL remotely. Log in to the Azure classic portal. Click Virtual Machines, click the name of your new virtual machine, and then click Endpoints.

  2. Click Add at the bottom of the page.

  3. Add an endpoint named "MySQL" with protocol TCP, and Public and Private ports set to "3306".

  4. To remotely connect to the virtual machine from your computer, type:

     mysql -u mysqluser -p -h <yourservicename>.cloudapp.net

    For example, using the virual machine we created in this tutorial, type this command:

     mysql -u mysqluser -p -h testlinuxvm.cloudapp.net