How to Setup MySQL Database |Mt Buzzer

How to Setup MySQL Database

Database Setup For MySQL, this task is not so difficult. Many people believe that  Database Setup For MySQL is an unwanted or critical task also they face errors like System error 1067 has occurred. Fatal error: Can't open and lock privilege tables: Table 'MySQL.user' doesn't exist .if you follow the correct steps than you can reach your ultimate goal.

This occurs when the Configuration Wizard tries to install the service and finds an existing service with the same name.

Let’s start to learn : How to Setup MySQL Database step by step.

1. Install MySQL Server
2. Configure MySQL Server
3. Create database and database user
4. Install Confluence
5. Download and install the MySQL driver
6. Enter your database details: Use a JDBC connection (default), Use a JNDI data source.

In to start with, Read this note for better setup of MySQL.

See Supported Platforms to check your form of MySQL is bolstered. You may need to overhaul your database before introducing Confluence. In case you're changing from another database, including the installed assessment database, read Migrating to Another Database before you start. In the event that you reinstall or redesign MySQL without first ceasing and evacuating the current MySQL benefit and introduce MySQL utilizing the MySQL Installer, you may see this mistake.

Intersection won't chip away at MySQL variations, for example, MariaDB (CONFSERVER-29060) and Percona Server (CONFSERVER-36471) 

How to Setup MySQL Database step by step

1. Install MySQL Server

If you don't start at now have MySQL presented, download and present it now. See the MySQL documentation for very much set up headings.


2. Configure MySQL Server

In this progression, you will design your MySQL database server.

Note: If you plan to associate Confluence to a current MySQL database server, we emphatically prescribe that you reconfigure this database server by going through the design ventures in the MySQL setup wizard as portrayed underneath. 

To setup MySQL Server:

Run the MySQL setup wizard:

If you are interfacing Confluence to your current MySQL server, pick Reconfigure Instance.

Choose Advanced Configuration.

Choose the sort of MySQL Server that best suits your equipment prerequisites. This will influence the MySQL Server's utilization of memory, plate and CPU assets. Allude to the MySQL documentation for additional data.
Choose Transactional Database Only to guarantee that your MySQL database will utilize InnoDB as its default stockpiling motor. 

You should utilize the InnoDB stockpiling motor with Confluence. Utilizing the MyISAM stockpiling motor can prompt information debasement in Confluence.

Set the InnoDB Tablespace settings to your prerequisites. (The default settings are adequate.)

Set the surmised number of simultaneous associations allowed to suit your Confluence utilization necessities. You can utilize one of the presets or enter a number physically. Allude to the MySQL documentation for additional data.

For the systems administration choices, guarantee the Enable TCP/IP Networking and Enable Strict Mode choices are chosen (default). Allude to the MySQL documentation on setting the systems administration and server SQL modes for additional data.

For the MySQL server's default character set, pick Best Support 
For Multilingualism (as it were, UTF-8). This will guarantee Confluence's help for internationalization. For more data, see Configuring Database Character Encoding. 

For the Windows design choice, pick regardless of whether to introduce the MySQL Server as a Windows benefit. On the off chance that your equipment will be utilized as a devoted MySQL Server, you may wish to pick the choices to Install As Windows Service(and Launch the MySQL Server consequently). Allude to the MySQL documentation for additional data.

Note: If you pick not to introduce the MySQL Server as a Windows Service, you should guarantee that the database benefit has been begun before running Confluence.

Select Modify Security Settings to enter and set your MySQL Server (root) get to the password.

Edit my.cnf document (my.ini on Windows working systems) in your MySQL server. Find the [mysqld]section in the document, and

include or adjust the accompanying parameters: 

(Allude to MySQL Option Files for nitty-gritty directions on altering my.cnf and my.ini.)
Find the [mysqld]section in the document, and include or alter the accompanying parameters:  

Specify the default character set to be UTF-8:




Set the default storage engine to InnoDB:





Specify the value of max_allowed_packet to be at least 256M:





Specify the value of innodb_log_file_size to be at least 2GB:




Ensure the sql_mode parameter does not specify NO_AUTO_VALUE_ON_ZERO

// remove this if it exists


Ensure that the global transaction isolation level of your Database had been set to READ-COMMITTED.





Refer that the binary logging format is configured to use 'row-based' binary logging.





Restart your MySQL server for the changes to take effect:

On Windows, use the Windows Services manager to restart the service.

On Linux:Run one of the following commands, depending on your setup: '/etc/init.d/mysqld stop' or '/etc/init.d/mysql stop' or 'service mysqld stop'.

Then run the same command again, replacing 'stop' with 'start'.

On Mac OS X, run 'sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart'.

3. Create database  user and database

Once you've installed and configured MySQL, create a database user and database for

 Confluence as follows:

Run the 'MySQL' command as a MySQL superuser. The default user is 'root' with a blank password.

Create an empty Confluence database schema (for example confluence):
CREATE DATABASE <database-name> CHARACTER SET utf8 COLLATE utf8_bin;
Create a Confluence database user (for example confluence user):
GRANT ALL PRIVILEGES ON <database-name>.* TO '<confluenceuser>'@'localhost' IDENTIFIED BY '<password>';
If Confluence is not running on the same server, replace localhost with the hostname or IP

 address of the Confluence server.

 4.Install Confluence

Check out the Confluence Installation Guide for step-by-step instructions on how to install Confluence on your operating system. 

5. Download and introduce the MySQL driver 

Because of permitting confinements, we're not ready to package the MySQL driver with Confluence. To make your database driver accessible to Confluence:

Stop Confluence.

Head to Database JDBC Drivers and download the suitable driver. The driver document will be called something like MySQL-connector-java-5.1.xx-bin.jar

Drop the .shake record in your <installation-directory>/intersection/WEB-INF/lib index. 
Restart Confluence at that point go to http://localhost:<port> in your program to proceed with the setup procedure. 

 Enter your database subtle elements 
The Confluence setup wizard will manage you through the way toward associating Confluence to your database.

Utilize a JDBC connection (default)

JDBC is the prescribed technique for interfacing with your database. 
The Confluence setup wizard will furnish you with two setup alternatives: 
Simple - this is the most direct approach to interface with your database. 

By association string - utilize this choice in the event that you need to determine extra parameters and are happy with developing a database URL. 

Utilize a JNDI data source
In the event that you need to utilize a JNDI data source, see Configuring a data source association for the means you'll have to take before you set up Confluence, as the setup wizard will just give the choice to utilize a data source in the event that it distinguishes a data source in your Tomcat setupment.

6. Enter your database details

The Confluence setup wizard will guide you through the process of connecting Confluence to your database.

Use a JDBC connection (default)
JDBC is the recommended method for connecting to your database.

The Confluence setup wizard will provide you with two setup options:

•    Simple - this is the most straightforward way to connect to your database.
•    By connection string - use this option if you want to specify additional parameters and are comfortable constructing a database URL. 

Depending on the setup type, you'll be prompted for the following information.
On the off chance that Confluence isn't running on a similar server, supplant localhost with the hostname or IP address of the Confluence server.

Introduce Confluence

Look at the Confluence Installation Guide for well-ordered directions on the most proficient method to introduce Confluence on your working system.

7. Test your database association

In the database setup screen, hit the Test association catch to check: 
Confluence can interface with your database server the database character encoding, grouping, segregation level and capacity motor are right your database client has suitable authorizations for the database.

Once the test is fruitful, hit Next to proceed with the Confluence setup process. 
If Confluence gripes that it is feeling the loss of a class document, you may have put the JDBC driver in the wrong envelope. 

If you get the accompanying mistake message, check that you have given the confluenceuseruser all the required database consents while associating from localhost. 
Couldn't effectively test your database: Server association disappointment amid exchange. Because of fundamental exemption: 'java.sql.SQLException: Access denied for client 'confluence user'@'localhost' (utilizing secret key: YES)' 
The following page contains regular issues experienced when setting up your MySQL database to work with Confluence: Known issues for MySQL 
Configuring a MySQL Datasource in Apache Tomcat 
Would you be able to run MySQL on a Mac?

Introducing and Running MySQL on Mac OS X. With more up to date forms of MySQL, it is winding up very simple to introduce MySQL on Mac OS X, particularly in the event that you are utilizing OS X 10.4 (Tiger) or 10.5 (Leopard). The initial step is to download the MySQL server. The installer introduces MySQL in the/usr/nearby/MySQL-variant catalog.

What is the utilization of MySQL workbench?

MySQL Workbench is a brought together visual device for database draftsmen, engineers, and DBAs. MySQL Workbench gives information demonstrating, SQL improvement, and extensive organization devices for server setup, client organization, reinforcement, and significantly more. MySQL Workbench is accessible on Windows, Linux, and Mac OS X. 
So, now you understand, now you understand How to Setup MySQL Database step by step.

Related Post:





Posted in: ,

Liked us? Tell your friends on Facebook!


Post a Comment