Mysql + php config

[dward]

Hello friends a little assistance here I have setup a new linux server for my php + mysql pages, but I'm receiving this error: "Could not connectAccess denied for user: 'root@localhost' (Using password: YES)". Does anybody knows why and how to solve this.

[CKnight]

Hello friends a little assistance here I have setup a new linux server for my php + mysql pages, but I'm receiving this error: "Could not connectAccess denied for user: 'root@localhost' (Using password: YES)". Does anybody knows why and how to solve this.

The local user does not have permission to access the database. Most default MySQL installations set up a root user with a blank password and that's pretty much what you'll get if you install MySQL from src or rpm. Keep in mind the the root user on MySQL is NOT the root user on the system.

If MySQL is installed using a package management system such as apt-get on certain distros such as (K)Ubuntu, then it is installed with a different default password, and you may be provided with additional setup tasks to set/retrieve a root password.

So first thing to do is try using a blank password for root, if that fails, dig around for documentation for your specific distro. This should be found on your system but google it if all else fails.

[dward]

Thanks CKnight for responding so quickly.

however, I'm not too sure of some of the stuff you say, I'm new to all this. All I did was to type the command setup and then selected mysql to start this service. Actual I inherit the server with most of the files on it.

So my next question is how could I change or Synchronize mysql password with that of root on the linux box.

Thanks in advance.

[VXDriven]

How was that you were trying to access MySQL? By surfing the PHP pages on the webserver (ie phpMyAdmin or CMS) or direct from commandline? If by surfing, were you surfing from a another computer?

You should really create a limited account to use for regular quaries for your pages. Anything more than "SELECT", "INSERT", "DELETE", "UPDATE" and "ALTER" is usually not recommended. If you want to be able to create databases and tables, then you can add "CREATE" to the list, but like I said its not recommended.