In order to connect to MySQLServer, you will need some client. The client can be the text based client (mysql monitor) or some graphical client example: MySQLWorkbench, HeidiSQL, SQLYog, DBeaver.

In order to connect to MySQL, you have to give these parameters:

• -h hostname (dns-name or ip-addres of the server)
• -u username
• -D database (optional)
• -p (if you connect with the password)

mysql -u username -h hostname -P 8889 -D database -p

show variables LIKE 'port';

SSL if available

MySQLWorkbench version 8.0.27 does not have the option use SSL if available and that might be a problem when you are connectiong to your local-server, which does not have SSL-support. You can change the configuration like this

1. Open to some editor file MySQL\MySQL Workbench...\modeules\data\mysql_rdbms_info
2. Search and replace these texts

      >2|Require,3|Require and Verify CA,4|Require and Verify Identity
      

   with these:

      >0|No,1|If available,2|Require,3|Require and Verify CA,4|Require and Verify Identity
      

Now you will have the option like in below image

This a very short manual to MySQL, you can found more details example from https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html

Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases.

When you create a table, you have to design which table type you are going to use. The various storage engines provided with MySQL are designed with different use cases in mind.

You can use below command to check which engines your server supports:

		SHOW ENGINES\G
	

And below command will show what are the table types in your database:

		SHOW TABLE STATUS\G
	

Here are some table types and their properties:

You can backup databases and tables with MySqlDump. It is very simple application, which will create the sql-code that you can use to create the databases and tables with the data.

Example Below command will backup Project database to file project.sql

  mysqldump -u root Project -p > project.sql

mysqldump -u root Project -p --routiness > project.sql

mysqldump -u root Project  Book -p >book.sql

  mysql -u root -D Project -p < mybackup.sql

User management is easiest to handle with some graphical client as MySQLWorkbench(instructions), dBForgeStudio or HeidiSQL. But still it useful to know the basic things behind this system.

MySQL stores all user information to table user inside database mysql.
You can check which users you have in your server, like this:

  SELECT User FROM mysql.user

And if you want to check also which are the allowed hosts for the users, you use can this:

  SELECT User,Host FROM mysql.user

You can create new user like this

CREATE USER 'testman'@'localhost' IDENTIFIED BY 'test_pass';

If you want to set the authentication to mysql_native_password, you can create the user like this

CREATE USER 'netuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'netpass';   

default_authentication_plugin=mysql_native_password

show variables LIKE '%default_authentication%';

  GRANT SELECT ON Project.* TO 'testman'@'localhost';

  GRANT SELECT,INSERT ON Project.* TO 'testman'@'localhost';

  GRANT ALL ON Project.* TO 'testman'@'localhost';

  REVOKE SELECT ON Project.* FROM 'testman'@'localhost';

  REVOKE SELECT,INSERT ON Project.* FROM 'testman'@'localhost';

  REVOKE ALL ON Project.* FROM 'testman'@'localhost';

DROP USER 'testman'@'localhost';

You can install just MySQL or some versions of XAMP: WAMP(Windows, Apache, MySQL, PHP), MAMP(MacOS, Apache, MysQL,PHP), LAMP(Linux, Apache, MySQL, PHP)) which includes MySQL.

UniServer (UniForm Server) is one version of WAMP. It is handy, because it doesn't need it to be installed. After unzipping the download file, you can start to use it. It is also easy to copy to another computer.

UniServer works only in Windows, if you are using Linux or Mac, you have to install some LAMP- or MAMP-version. When you start UniServer, you will see the Control Panel:

From this panel you can start and stop Apache and MySQL. You can also start MySQL Console and Server Console. Server Console is just a Windows command line and MySQL Console is MySQL-monitor.

The easiest way to install MySQL to MAC is probably to use Homebrew.

If you don't have Homebrew in your MAC, you can get it from https://flaviocopes.com/homebrew/

All you have to do is execute command

brew install mysql

brew services start mysql

mysql.server start

The root password is not set, so you should set it after installation like this:

• Connect to your MySQL with the command mysql -u root
• Execute command SET PASSWORD='somepassword'

If you don't need Apache, it is better to install only MySQL as described in the previous section.

But if you need also Apache, you can install Xampp from https://www.apachefriends.org or MAMP from https://www.mamp.info/.

And this instructions is for the XAMPP version which runs in virtual machine.

When you start the Xampp, you will see below control-panel

When you click Services, you will see below window, which you can use to start/stop applications.

If you go back to mainwindow (click General), you can open the terminal by clicking "Open Terminal". And then you can connect to MyQL(MariaDB), by typing mysql -u root -p. In the beginning there is no password, so you can connect with the command mysql -u root and configure a password with the command SET PASSWORD=PASSWORD('test');

Connecting to MySQL: when you connect to your server, example from MySQL-Workbench, you have to use the ip-address of the virtual machine, which you can see on the main window, . (So, you can not use localhost).

Web-folder in Mac-Xampp the web-folder is htdocs, but you have to first Mount the folder from the control-panel, so click Volumes->Mountand then Explore. And you can reach it from the commandline inside your home folder and then .bitnami/stackman/machines/xampp/volumes/root/.

You will be able to open the folder in Terminal easily, if you first make this:

• Head into System Preferences and select Keyboard > Shortcuts > Services. Find "New Terminal at Folder" in the settings and click the box.

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

You can find a tutorial for using MySQLWorkbench from https://www.guru99.com/introduction-to-mysql-workbench.html

And the manual for MySQLWorkbench from https://dev.mysql.com/doc/workbench/en/

If you have problems with the installation check this https://dev.mysql.com/doc/workbench/en/wb-installing.html
(Example in Windows you might need to install C++ Redistributable.)