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    
-
     
+
 
-
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 "secret"  
+
      # mysqladmin -u root password "XXXX"
-
 
+
      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
         # mysql -u username -p
-
         this will prompt for the password entering the password  
+
         this will prompt for the password, entering the password  
         will take you to the mysql prompt.
         will take you to the mysql prompt.

Current revision as of 09:09, 24 November 2010