End Google Ads 201810 - BS.net 01 --> am working on a micro-finance accounting system, and i have decided to use MySQL as the database. I have installed MySql 4.01, and have everything including the Server, Admin, and connector installed and running fine.

Am currently trying to test a means of loading data into a datagridview from one of the tables in the MySql db. But app fails when i try to open a connection to the db:

MySqlConnection con = new MySqlConnection("server=localhost;database=pets;uid=root;password=alchemy@6");

con.Open(); //creates error "Access denied for user 'root'@'localhost' (using password: YES)"

can someone help me?