Posts

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 &
Post a Comment
Read more

Starting off with MySQL shell 8.0 on Windows

Database is mainly used in storing data in the form of records(rows) and fields(columns). MySQL is an open source relational database management system which provides us with a wide variety of tools for managing the database. Recently when I installed MySQL installer which consisted of: MySQL Server MySQL Connectors MySQL Workbench and sample models Sample Databases MySQL for Excel MySQL Notifier MySQL for Visual Studio Documentation MySQL shell was  an interactive Javascript, Python, or SQL interface supporting development and administration for the  MySQL  Server and is a component of the  MySQL Server.  Initially, I had some difficulty to start and work with MySQL shell which was slightly different from the traditional MySQL shell in terms of connecting and many more features.  If we need the traditional mysql shell C:\Program Files\MySQL\MySQL Server 8.0\bin >  mysql  -u user -p eg: mysql -u root -p then it will ask you to enter your password. Comin
1 comment
Read more