Tuesday, December 14, 2010

MYSQL starters for dummies

reset password
c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe --init-file=C:\\mysql-init --console

file here
Source: MySQL.com
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

MySQL commands:
show databases;
create database [db_name];
drop database [db_name];

Problem:
Unable to connect to the database:Could not connect to MySQL

Fix: Change hostname to from "localhost" to "127.0.0.1"

No comments:

Post a Comment