Scribd
Upload
12 views2 pages

MySQL Installation and User Guide

This MySql Setup User Manual provides a step-by-step guide for installing MySql on various operating systems, including setting up a root user and configuring the database. It covers creating a database and tables, integrating with Java, and backing up the database using mysqldump. The document emphasizes the importance of remembering the root credentials and port configurations during installation.

Uploaded by

t53926251
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views2 pages

MySQL Installation and User Guide

This MySql Setup User Manual provides a step-by-step guide for installing MySql on various operating systems, including setting up a root user and configuring the database. It covers creating a database and tables, integrating with Java, and backing up the database using mysqldump. The document emphasizes the importance of remembering the root credentials and port configurations during installation.

Uploaded by

t53926251
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MySql Setup User Manual

Step 1.
Go to MySql Official Website [Link] and
choose the appropriate version of your OS(Operating Systems eg. Windows,
Linux and etc.).

Step 2.
Install MySql in your computer, if you’re using windows the installation file
will be found in the Downloads folder and then install it.

Step 3.
Before it completely install it will ask you to enter your root name and the
password so you need to provide the following information and if you have
other applications or server running in port 3306 since 3306 is the default
port for some databases so you can also change its port by your choice
since it would be a conflict if it is running in the same port, you also need to
remember this informations because this would be use later.

Step 4.
Open your start up menu and seek for mysql command client or something
like this and open it then it ask to enter your password so provide the
password you entered earlier then you can create Database by running this
command Create database my_db; don’t worry MySql is not case sensitive.

Step 5.
Then to use your database you can run this query use name_of_database;
then you can create table of your choice example query Create table
newDatabase(Name varchar(50), Status varchar(10), primary key (Name));
but if you have any dump sql files, relations, data or etc. you can run this
query source: the_name_of_directories and add .sql at the end.

Step 6.
In this user’s guide we use java as an example for database integration guide
since we’re using java. To established connection in your database together
with your programs, applications or etc. you need first to download first the
java drivers it is a java library for database purposes and you can download
it via the website of oracle then after you can install it in your java folders
find libraries and add the driver then write a constructor or objects(don’t
forget the imports) to handle the database connection logic.

Step 7.
If you wanna take your dump sql files and commit it in any repositories kindly
type this command in you MySql command client mysqldump -u root -p
my_database > my_database_backup.sql then you will get the dump_sql file.

You might also like