Step 1. Install mysql-essential-5.0

Following Command To install that .

start mysql-essential-5.5.12-win32.msi /quiet /norestart

Step 2. Set configuration

Run Following Command line For That .

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

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

5.5" -v5.5.12 "-tC:\Program Files\MySQL\MySQL Server

5.5\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.5
cd bin
mysql -u root
GRANT ALL PRIVILEGES ON . TO 'Root'@'%' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;
exit

IS this post for instructional purpose or do you have a question about the code above?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.