![]() ![]() Then restart Tomcat using sudo service tomcat restart, launch browser and go to and you can see: On nf change the value of TOMCAT_USER from tomcat to root on line 27: The command format of create table by using sql script is: `id` bigint( 20) unsigned NOT NULL AUTO_INCREMENT, sql file using vim, here we name it as table_demo.sql, and fill SQL script into it:ĭROP TABLE IF EXISTS `demo`. Here we create a schema named demo by running: Now we have granted the privilege of the anonymous user. We want the anonymous user can access to the database without password from anywhere, that means the username should be an empty string as well as the password accessing from anywhere means the user’s host can be *, then we run the grant command and flush the privileges: Grant all on shemaname.tablename to 'userhost' Here we need to grant the privilege of anonymous user, The command format of granting privilege is: ![]() In this case, we need to change the information in a table named user of the mysql schema, here we use use mysql to swith to that schema, and then select main information of all users from table user: Show databases // show all the schema in the MySQL database As all the user information are stored in the schema named mysql, we can use show databases to list all schemas in the database: Now we can login to MySQL using root user by executing mysql -u root. Then start MySQL service by executing sudo service mysqld start, here are three command related to MySQL start, stop and restart: SSH to the instance, run mysql to check if MySQL is available on it. First we nee to launch an Amazon EC2 instance and install Java on it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |