Hi,
Stange thing; my config.local.php file has the wrong user and database credentials, and even so, everything seems to work. The database connection options are not commented out and I'm shure the user and password are wrong, so, how is the store working? Do I need to change the user and password on the config.local or should I leave it as it is?
Thank you,
Tânia
Hi,
Stange thing; my config.local.php file has the wrong user and database credentials, and even so, everything seems to work. The database connection options are not commented out and I'm shure the user and password are wrong, so, how is the store working? Do I need to change the user and password on the config.local or should I leave it as it is?
Thank you,
Tânia
local_conf.php can be used. Please check.
I'm guessing that the database username and password have nothing to do with mysql credentials...
I'm guessing that the database username and password have nothing to do with mysql credentials...
What do you mean? Please clarify
When I access in the browser to MySQL I use a username and a password, these are different from the username and password of the database itself, at least according to the info on config.local.php
And I thought they where supposed to be the same (MySQL and database name), but I'm guessing that to access MySQL is one thing and the database itself is another, in fact, I never need to input username and password for accessing it (wich I find very confusing by the way), is this correct?
Thank you!
When I access in the browser to MySQL I use a username and a password, these are different from the username and password of the database itself, at least according to the info on config.local.php
And I thought they where supposed to be the same (MySQL and database name), but I'm guessing that to access MySQL is one thing and the database itself is another, in fact, I never need to input username and password for accessing it (wich I find very confusing by the way), is this correct?
It is very strange and not secure. Inform hosting administrator about this fact
Let me see if I can explain better:
1. At the time of the setup of the server, the hosting company gave me username and password to access CPanel and MySQL, it is the same password for both.
2. When the cs cart database was created (uppon my store instalation), the developer gave it a different username and password from that of the server.
3. I access MySQL on a daily basis and allways use the user and password given to me by the hosting company. I'm able to perform routine operations on my CSC database (delete, change, optimize tables, etc.) with these credentials.
So, my question is: the username and password of the database itself are not needed for me to open it using CPanel and MySQL?
In fact, the developer didn't inform me of this database username and password, so maybe it has nothing to do with it.
Truth be told, I can have multiple databases accesible with MySQL and each one has it's one different username and password... (I think I'm answering myself now... :huh: ), I guess the server one is the root password and can access any database inside.
Sorry for this extendend doubt, but before the upgrade I had the same username and password for Cpanel, MySQL and database itself, so I'm confused.
You can have a database with multiple users and different permissions. Suggest you either look at the information schema in the DB or use cPanel to see what users have access to your db. I would assume that you have multiple users assigned and that you use one in phpMyAdmin and a different user in config.local.php.
All is good. If the credentials in config.local.php were invalid, your store would not launch.
So, my question is: the username and password of the database itself are not needed for me to open it using CPanel and MySQL?
In fact, the developer didn't inform me of this database username and password, so maybe it has nothing to do with it.
Truth be told, I can have multiple databases accesible with MySQL and each one has it's one different username and password... (I think I'm answering myself now... :huh: ), I guess the server one is the root password and can access any database inside.
Sorry for this extendend doubt, but before the upgrade I had the same username and password for Cpanel, MySQL and database itself, so I'm confused.
Developer did right action. I think that you agree with me that is not secure to store root access of the server in the config.local.php file. Therefore additional database user with another username and password was created by the developer
Oh but I did not think that it was not right! I just didn't know it was possible you see, I allways had the same user and password, so I was only confused because I didn't even know it was possible :roll: .
Nowadays it is not recommended to use one password for all accounts :)