Recently I've started to explain how to install quickly the new MySQL Cluster NDB 7.3 and now I'm ready to continue.
Let's start, shall we ?
STEP 2 : On every SQL Nodes execute the following command as root:
[root@MysqlVm04ClusterData1 mysql]# cd /usr/local/mysql
[root@MysqlVm04ClusterData1 mysql]# scripts/mysql_install_db --user=mysql
NB:
If we want to change the root password of MySQL database or remove the
anonymous user we have to execute the following command :
$BASE_DIR/bin/mysql_secure_installation
The "mysql_install_db" command is necessary to create the system databases on the SQL Nodes. Afterwards we can modify the .bash_profile file of mysql user adding the following row :
export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/mysql/bin
STEP 3: On all Data Nodes we have only to be sure of adding the binary directory of MySQL in the environment variable PATH
export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/mysql/bin
To be continued ....
See you in my next Blog.
Byeee
No comments:
Post a Comment