MySQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "# Create a user and grant permission in mysql # http://www.cyberciti.biz/faq/mysql-user-creation/ mysql -u root -p CREATE DATABASE demo; GRANT ALL ON demo.* TO guest@localhost I…") |
No edit summary |
||
| Line 1: | Line 1: | ||
== Create a user and grant permission in mysql == | |||
http://www.cyberciti.biz/faq/mysql-user-creation/ | |||
<pre> | |||
mysql -u root -p | mysql -u root -p | ||
CREATE DATABASE demo; | CREATE DATABASE demo; | ||
GRANT ALL ON demo.* TO guest@localhost IDENTIFIED BY 'guest123'; | GRANT ALL ON demo.* TO guest@localhost IDENTIFIED BY 'guest123'; | ||
</pre> | |||
== create a database 'demo' and a table 'employee' == | |||
http://www.thegeekstuff.com/2011/10/mysql-tutorial-basics/ | |||
<pre> | |||
mysql -u guest -p demo | mysql -u guest -p demo | ||
show databases; | show databases; | ||
| Line 17: | Line 18: | ||
insert into employee .............; | insert into employee .............; | ||
select * from employee; | select * from employee; | ||
</pre> | |||
== access mysql using perl == | |||
http://www.cyberciti.biz/faq/how-to-access-mysql-database-using-perl | |||
Revision as of 10:14, 7 November 2012
Create a user and grant permission in mysql
http://www.cyberciti.biz/faq/mysql-user-creation/
mysql -u root -p CREATE DATABASE demo; GRANT ALL ON demo.* TO guest@localhost IDENTIFIED BY 'guest123';
create a database 'demo' and a table 'employee'
http://www.thegeekstuff.com/2011/10/mysql-tutorial-basics/
mysql -u guest -p demo show databases; use demo; show tables; create table employee .............; desc employee; insert into employee .............; select * from employee;
access mysql using perl
http://www.cyberciti.biz/faq/how-to-access-mysql-database-using-perl