Re: Error installing: Unable to update security settings.
Posted by:
Fidel -
Date: May 17, 2011 03:43AM
Hi,
I created the user and enabled it with these commands:
CREATE USER 'dummy_guy'@'localhost' IDENTIFIED BY 'dummy_pw';
GRANT ALL PRIVILEGES ON *.* TO 'dummy_guy'@'localhost' WITH GRANT OPTION;
The problem is obviously not there.
I am trying to see the database from SQLiteManager (A graphic application to see any database).
I specified the host (both localhost and 127.0.0.1), the port 3306 (Which is where the process is listening, as I have checked that with netstat), the user (dummy_guy), the password (dummy_pass) and the database (which I created previously and has tables and data).
Nevertheless, it is not reachable. (I also tried with root user)
I have tried with other applications (For example, Windows ODBC Data Sources), and I have the same problem (Message: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061).
So this is not exactly an easy issue, is it?