Pages

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

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