Install the the client and server software
$ sudo yum install mysql
$ sudo yum install mysql-server
start mysql server
$ sudo service mysqld start
automatically start mysql daemon on startup
$ sudo chkconfig --level 2345 mysqld on
set root password
$ mysqladmin -u root password foobar
login to localhost server
$ mysql -u root -p
mysql>
create a new user
mysql> create user 'username'@'localhost' identified by 'password';
mysql>
create a new user
mysql> create user 'username'@'localhost' identified by 'password';
mysql> grant all privileges on *.* to 'username'@'localhost' with grant option;
mysql-workbench: admin GUI
$ sudo yum install mysql-workbench
Tutorial on creating a database using mysql-workbench here
No comments:
Post a Comment