You need to grant privileges to 'root'@'127.0.0.1' because it is not the same thing
as 'root'@'localhost'.


Timotius Alfa wrote:

Pls help me, I want to know if this connection string can be used for multi user, coz when I change "Server=localhost" with "server=127.0.0.1" it can not work. thanks

Connect_Str = "Driver={MySQL ODBC 3.51 Driver};" & _
                 "SERVER=127.0.0.1;" & _
                 "Database=sekolah;" & _
                 "UID=root;PWD=tim; OPTION= " & 1 + 2 + 8 + 32 + 2048 + 16384



---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search





-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to