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

 

Related Other posts

Sorting, Paging, Add, Update, Delete in GridView Check / Uncheck all checkbox in treeview using jquery Image In Datalist Merge docs files in c#

Bind Treeview in asp.net c# using dataset CheckboxList example Datetime format in gridview Send mail in asp.net c#

Highest second record in sql Nested gridview Checkboxs in gridview Validation using jquery in asp.net page

Using Command Prompt Options to Install SQL Server Express

Using Command Prompt Options to Install SQL Server Express :-

Installation Of Sql Server 2005 Using Command Prompt( Silent Mode )

Here is the command line I am using : -

Start /wait SQLEXPR32.exe   /qb INSTANCENAME=MSSQLSERVER  INSTALLSQLDIR="C:\Program Files" TALLSQLSHAREDDIR="C:\ProgramFiles" ADDLOCAL=All ERRORREPORTING=1 SQLAUTOSTART=1 SQMREPORTING=1 SAPWD=Lobby@123 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1

To install SQL Server Express 2008 following is the command-line

SQLEXPR32_x86_ENU.exe /q /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS
   /INSTANCENAME=SQLSERVER /ROLE=AllFeatures_WithDefaults
   /ADDCURRENTUSERASSQLADMIN=TRUE /SQLSVCACCOUNT="NT AUTHORITY\Network Service"
   /FEATURES=SQL

Related Other posts

Sorting, Paging, Add, Update, Delete in GridView Check / Uncheck all checkbox in treeview using jquery Image In Datalist Merge docs files in c#

Bind Treeview in asp.net c# using dataset CheckboxList example Datetime format in gridview Send mail in asp.net c#

Highest second record in sql Nested gridview Checkboxs in gridview Validation using jquery in asp.net page