Send Article
Comment
Print
Create a new database
First, we create a new and empty database called “jlicensure”. On windows, run Start->My Programs->MySQL->MySQL Server 5.x->MySQL Command Line Client and enter the root password you assigned during installation. On other platforms, run “mysql -uroot”.
Enter “create database jlicensure;” and hit enter as shown above. Enter “quit” to leave the mysql command line tool. Please note that you can use any name for your database. You may of course also use an existing database, in which case you may skip this step.
If you want to create a new user and password to access the newly created database, please refer to the MySQL manual. Usually, a new user can be created by entering something like this into the mysql command line tool:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
