using : mysql-installer-web-community-5.6.14.0.msi

link : http://dev.mysql.com/downloads/mirror.php?id=414473

Configuration steps :

pwd: mySQLmanas8

Added another user: admin/admin237, role DB Admin has all options

 


mysql-server-5.6-winx64:6 - Looking for valid template
mysql-server-5.6-winx64:12 - Found valid template.
mysql-server-5.6-winx64:18 - Attempting to process template.
mysql-server-5.6-winx64:25 - Processed template.
mysql-server-5.6-winx64:31 - Attempting to configure service.
mysql-server-5.6-winx64:37 - Configured service.
mysql-server-5.6-winx64:43 - Attempting to start service.
mysql-server-5.6-winx64:50 - Started service.
mysql-server-5.6-winx64:56 - Adding firewall rule for MySQL56_1 on port 3306.
mysql-server-5.6-winx64:62 - Successfully added firewall rule.
mysql-server-5.6-winx64:68 - Attempting to update security settings.
mysql-server-5.6-winx64:75 - Updated security settings.
mysql-server-5.6-winx64:81 - Attempting to verify command-line client shortcut.
mysql-server-5.6-winx64:87 - Verified command-line client shortcut.
mysql-server-5.6-winx64:93 - Verified command-line client shortcut.
mysql-server-5.6-winx64:100 - Attempting to Add New MySQL Users
mysql-server-5.6-winx64:100 - Added New Users.
mysql-server-5.6-winx64:100 - Product configuration controller finished configuration.
examples-5.6:10 - Checking if there are any features installed that need configuration.
examples-5.6:100 - Product configuration controller finished configuration.
 

Make sure that my.ini path is correct.

Created new connection/ new /

 

 

testing with php

http://manas8x/BareBone_PHP/mysql_test1.php

<?php
// mysql_test1.php
//mysqli_connect('localhost','root', NULL, 'people');
//$ip = $_SERVER('SERVER_NAME');
//$con=mysqli_connect("Manas8x.gateway.2wire.net","manas8x","","test");
$con=mysqli_connect("localhost","admin","admin237","test");
// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
// echo $ip. ": SERVER <br/>";
/* print server version */
printf("Server version: %s\n", mysqli_get_server_info($con));
echo "<br/> databse test connected using mysql_connect function";
echo "<br/> host name ". gethostname(). "<br/>";
echo "php_uname " .php_uname();
mysqli_close($con);
echo "<br/> connection to db closed";
?>
 

Back to MySQL workbench

There is no connect command with mysql , use db is equivalent to connect db