• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

PHP

“Access denied for user ‘username’@’hostname’ (using password: YES)” – Error while connecting MySQL with PHP

By admin

The Problem If the MySQL password contains a dollar sign character '$', PHP is unable to connect and issues an error like: Access denied for user 'username'@'hostname' (using password: YES) Connections via other clients work correctly. The Solution PHP interprets dollar signs inside of double quotes as starting a variable name, which will be expanded. This expansion will change the password sent to MySQL. There are 3 ways to avoid this problem: Escape the character with a … [Read more...] about “Access denied for user ‘username’@’hostname’ (using password: YES)” – Error while connecting MySQL with PHP

Filed Under: mysql, PHP

How to test a PHP script

By admin

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP runs on all major operating systems, from Unix variants including Linux, FreeBSD, Ubuntu, Debian, and Solaris to Windows and Mac OS X. It can be used with all leading web servers, including Apache, Nginx, OpenBSD servers to name a few; even cloud environments like Azure and Amazon are on the rise. Below are some of the ways in which a PHP script can be … [Read more...] about How to test a PHP script

Filed Under: Linux, PHP

Primary Sidebar

Recent Posts

  • How to set the default character set in MySQL and how to propagate it in a master-master replication scenario
  • “Connection reset by peer” – error while ssh into a CentOS/RHEL system with a specific user only
  • MySQL: how to figure out which session holds which table level or global read locks
  • Recommended Configuration of the MySQL Performance Schema
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary