Setup - Linux‎ > ‎

MySQL






Install & enabling mysql :

 

Ø For fedora:

Just type those commands below:

 

ü  yum -y install mysql-server

ü  /etc/rc.d/init.d/mysqld start

ü  chkconfig mysqld on

 

Ø For  Ubuntu:

 

Ø  sudo apt-get install -y mysql-server

2. Setting password for the database :

Ø  For Ubuntu:

Password must be entered while installing the package:

(Don’t forget your password because in most of time if you lose it you lose you life)





Ø  for fedora:

type those commands below:

 

ü  mysql –uroot

ü  mysql> set password=password(“secret”);                   # secret is the password you choose for the database

ü  mysql> exit

 

Now you have installed Mysql Database




Setup lower case tables names

NOTE: Make sure your mysql installation is case insensitive by adding the below line into my.cnf file

lower_case_table_names= 1


Setup mycp schema : 



One the database is up and running, open up a mysql shell and run the mycloudportal related sql files to create the schema and populate it with initial data.


Create mycp schema 

ü  Create the mycp database in MySQL using its shell.




Execute DDL script

ü  read through the mycp.ddl.sql file and follow the instructions there.

you will need to import the latest mysqldump  file and then execute the scripts in .dml file



execute DML script

ü  Then execute the sql commands in " mycp.dml.sql" file found in root of the mycloudportal sources and commit.




check tables


ü  The "show tables" should show the above 45 tables created.








Comments