I hope you liked this tutorial, dont forget to share it with others.This is not a post that most of my readers will generally need to worry about, but instead this is more of a PSA for those of you that are running MacOS Sierra and are web developers. We have completed the MySQL tutorial, and In this tutorial, we learned how to install MySQL community server on Mac OS, How to access root user in the MySQL server, Create Database and Table. CREATE TABLE IF NOT EXISTS `Users ` ( `id ` int ( 11 ) NOT NULL AUTO_INCREMENT, ` name ` varchar ( 256 ) NOT NULL, `email ` varchar ( 50 ), `age ` int ( 11 ) NOT NULL, `mobile ` VARCHAR ( 20 ), `created ` datetime NOT NULL, PRIMARY KEY ( `id ` ) ) ENGINE = InnoDB DEFAULT CHARSET =utf8 AUTO_INCREMENT = 19 mysql > use positrondbĬreate a table in the MySQL database => ‘positrondb’. Use the newly created “positrondb” db by using the below command. | information_schema | | mysql | | performance_schema | | positrondb | | sys | You can verify the newly created MySQL database. Now we will use the mysql query to create a new database. Type ' \c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.20 MySQL Community Server - GPLĬopyright (c ) 2000, 2020, Oracle and/or its affiliates. mysql -u root -p Welcome to the MySQL monitor. So you have to type the password that you defined when installing the MySQL initially. When you run the following command it will ask for the password. We are all set with the server configurations, now we have to access the MySQL root. Now, we have reached to essential step of our tutorial. To verify the current status of MySQL server: rver status Access Root via Mac Terminal
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |