Friday, May 30, 2008

silent installation of Mysql server 5.0

Here Is Command Line For silent installation of Mysql server 5.0

Step 1. Install mysql-essential-5.0

Following Command To install that .

start mysql-essential-5.0.45-win32.msi /quiet /norestart
Step 2. Set configuration

Run Following Command line For That .


cd\
cd Program Files
cd MySQL
cd MySQL Server 5.0
cd bin
MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt"

"-nMySQL Server 5.0" "-pC:\Program Files\MySQL\MySQL Server

5.0" -v5.0.45 "-tC:\Program Files\MySQL\MySQL Server

5.0\my-template.ini" "-cC:\mytest.ini" ServerType=DEVELOPMENT

DatabaseType=MIXED ConnectionUsage=DSS Port=3306 ServiceName=

RootPassword=pass
break
exit
Step 3. give it full privileges to connect from external and localhost client:

cd\
cd Program Files
cd MySQL
cd MySQL Server 5.0
cd bin
mysql -u root
GRANT ALL PRIVILEGES ON *.* TO 'Root'@'%' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;
exit

 Kindle Wireless Reading Device, Wi-Fi, Graphite, 6" Display with New E Ink Pearl Technology


Related Other posts

3 comments:

  1. hi i am using mysql server 5.1.51. i followed your code to configure mysql server. but it is not configured. it shows error like below:

    could not open require default file: C:\Program Files\MySQL\MySQL Server 5.1\my.ini.
    fatal error in default handling. program aborted.

    i am using the code

    MySQLInstanceConfig.exe -i -q “-lC:\mysql_install_log.txt” “-nMySQL Server 5.1″ “-pC:\Program Files\MySQL\MySQL Server 5.1″ -v5.1.51 “-tC:\Program Files\MySQL\MySQL Server 5.1\my-template.ini” “-cC:\mytest.ini” ServerType=DEVELOPMENT DatabaseType=MIXED ConnectionUsage=DSS Port=3306 ServiceName=MYSQL RootPassword=pass

    help me

    thanks in advance

    ReplyDelete

  2. This is .bat file ?

    ReplyDelete

Subscribe to: Post Comments (Atom)