Member Avatar for duchaine

Hi,

No matter what I do I get the Access denied for user error.I watched the video but still get it.

Are there any common errors I should be aware of in setting up a db user?

Thanks,
duchaine

  • 3 Contributors
  • 2 Replies
  • 118 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by bugz313

Dani AI

Generated

Short, practical checklist that expands on ’s question about OS/version and on ’s note about credentials/host mismatches.

Common causes to check quickly: wrong password, the MySQL user is defined for a different host (MySQL matches user+host), connector/ODBC driver and MySQL auth-plugin mismatch (MySQL 8 uses caching_sha2_password by default), and ODBC bitness mismatch when using Microsoft Access.

Troubleshooting steps and useful commands:

# try a direct login from the DB host (forces TCP with 127.0.0.1)
mysql -u your_user -p -h 127.0.0.1

# inspect the user entries and plugin
SELECT User, Host, plugin FROM mysql.user WHERE User='your_user';
SHOW GRANTS FOR 'your_user'@'host';

# create/grant examples (adjust privileges as needed)
CREATE USER 'your_user'@'%' IDENTIFIED BY 'strongpass';
GRANT SELECT, INSERT ON yourdb.* TO 'your_user'@'%';
FLUSH PRIVILEGES;

# if connector is old and server is MySQL 8+, switch auth plugin
ALTER USER 'your_user'@'%' IDENTIFIED WITH mysql_native_password BY 'strongpass';

Notes and cautions specific to Access/ODBC:

  • Match ODBC driver bitness to Access (32-bit Access needs a 32-bit ODBC driver even on 64-bit Windows).
  • Use the MySQL Connector/ODBC version appropriate for the server (older connectors may not support MySQL 8 auth).
  • In DSN settings prefer specifying the host/IP and test the DSN with the ODBC admin tool; some clients treat localhost differently (socket vs TCP).
  • Don’t grant broad privileges to application accounts; avoid using root for app connections.

Useful diagnostic data when diagnosing further: the exact error text, MySQL server version, connector/ODBC/driver name and bitness, and whether the client is local or remote. These let one distinguish wrong password, host-mismatch, auth-plugin issues, or driver incompatibility.

Recommended Answers

All 2 Replies

Member Avatar for cereal

Hi,

are you using MySQL on Windows? Is this a new installation? Which version? Could you paste the specific message and code error?

Member Avatar for bugz313

Your username, password or host might be wrong.... need more details

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.