rilpoint_mw113

Mysql Database

 
Line 4: Line 4:
To install mysql in Boss, run the following command from shell  
To install mysql in Boss, run the following command from shell  
-
       # apt-get install mysql-server-5.0 mysql-client-5.0
+
       # apt-get install mysql-server-5.0 mysql-client-5.0    
-
      mysql is installed now.
+
 
-
 
+
To set the root password, run the following command from your shell prompt
-
To set the root password,run the following command from your shell prompt
+
      # mysqladmin -u root password "XXXX"
-
  mysqladmin -u root password "secret"  
+
      replace XXXX with the password you want.
-
    replace secret with the password you want.
+
Now you can access mysql by running  
Now you can access mysql by running  
-
         # mysql -u username -p ,this will prompt for the password entering the password will take you to the mysql prompt.
+
         # mysql -u username -p
 +
        this will prompt for the password, entering the password  
 +
        will take you to the mysql prompt.

Current revision as of 09:09, 24 November 2010