Comments - mysqli_connect did not work

7 years, 11 months ago Ian Hudson

OK. Thanks. Now, I replaced what you said was object-oriented. I just copied the Example #1 mysqli_connect() from http://uk1.php.net/manual/en/function.mysqli-connect.php and I think it has given me its reason why I cannot connect: Debugging errno: 1045 Debugging error: Access denied for user 'iph'@'localhost' (using password: YES) Now I have 2 questions: Where do I look up error numbers like 1045? and how in MariaDB do I check which user name and password I managed to set up for myself and therefore what values I should be using in this function call?! I am afraid that I find the website documentation labyrithine and perplexing.

 
7 years, 11 months ago Ian Gilfillan

Error codes are listed at MariaDB Error Codes.

You can query the mysql.user table to view which host/users have been set up:

select host, user, password from mysql.user;

However, the passwords are hashed, so you will not be able to view the passwords used.

You may also want to look at Troubleshooting Connection Issues.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.