Code:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=league; Uid=leagueDB; Pwd=l672Vgg;"
%>
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user 'leagueDB'@'localhost' (using password: YES)
/amatuer/inc/db_conn.asp, line 3
I have ran this commad in the MySQL command line:
GRANT ALL PRIVILEGES ON *.* TO leagueDB@localhost IDENTIFIED BY 'l672Vgg' WITH GRANT OPTION;
I also have added leagueDB and the password into the 'user' table in the mysql DB (mysql.user). So that it looks like this......
+------------+
| user |
+------------+
|leagueDB |
|root |
+------------+
What do i need to do to access the DB in my script and SQLyog???
Help appreciated.
Picco
www.crmpicco.co.uk
www.ie7.com
connect to MySQL DB -(0x80004005)
