INST 327 Lecture Notes - Lecture 8: Mysql, Superuser

68 views4 pages

Document Summary

So assuming you have access to the root user, you can create any database using the mysql mysqladmin binary. Here is a simple example to create a database called tutorials . This will create a mysql database called tutorials. The following example to create a database . You would need special privileges to create or to delete a mysql database. So, assuming you have access to the root user, you can create any database using the mysql mysqladmin binary. Be careful while deleting any database because you will lose your all the data available in your database. Here is an example to delete a database(tutorials) created in the previous chapter . This will give you a warning and it will confirm if you really want to delete this database or not. Try the following example to delete a database . Php uses mysql_query function to create or delete a mysql database.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents