Creating a MYSQL Database
In my previous post, I had introduced databases and different applications of the database. Although the pertinent part of the post was on how to use Microsoft windows shell there was more information about MySQL basics. Moving on... Once the set up of MYSQL database is done we need to create a database that can be accessed by other applications (acts as a backend to many web-applications). Creation of Database mysql > create database database_name ; this above command is used to create a database, various errors you might encounter while creation of database are : ERROR 1007 (HY000): Can't create database' database_name '; database exists - database already exists ERROR 1044 (42000): Access denied for user ' user _name '@'%' to database ' database_name ' - user has no access permission mysql > use database_name ; ERROR 1049 (42000): Unknown database ' database_name ' ERROR 1044 (42000): Access denied for user &