yum install mysql mysql-server mysql-libs mysql-server
service mysqld start
chkconfig --levels 235 mysqld on
mysqladmin -u root password 'root'
mysql -h localhost -u root -proot
show databases;
use bedrock; -- Specify database to connect to. Also refers to path: /var/lib/mysql/bedrock
show tables;
create table employee (Name char(20),Dept char(20),jobTitle char(20));
DESCRIBE employee; -- View table just created. Same as "show columns from employee;"
service mysqld stop
service mysqld start
chkconfig --levels 235 mysqld on
mysqladmin -u root password 'root'
mysql -h localhost -u root -proot
show databases;
use bedrock; -- Specify database to connect to. Also refers to path: /var/lib/mysql/bedrock
show tables;
create table employee (Name char(20),Dept char(20),jobTitle char(20));
DESCRIBE employee; -- View table just created. Same as "show columns from employee;"
service mysqld stop