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:
[mysqld]...
character-set-server=utf8
collation-server=utf8_bin
Set the default
storage engine to InnoDB:
[mysqld]
...
default-storage-engine=INNODB
...
Specify the value
of max_allowed_packet to be at least 256M:
[mysqld]
...
max_allowed_packet=256M
...
Specify the value
of innodb_log_file_size to be at least 2GB:
[mysqld]
...
innodb_log_file_size=2GB
...
Ensure the sql_mode
parameter does not specify NO_AUTO_VALUE_ON_ZERO
// remove this if
it exists
sql_mode =
NO_AUTO_VALUE_ON_ZERO
Ensure that the
global transaction isolation level of your Database had been set to
READ-COMMITTED.
[mysqld]
...
transaction-isolation=READ-COMMITTED
...
Refer that the
binary logging format is configured to use 'row-based' binary logging.
[mysqld]
...
binlog_format=row
...
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.
Investigating
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:
0 comments:
Post a Comment