mySQL help connect

[gfx25]

// MySQL server location ex. (mysql.example.com)
$host = "localhost";
// The user name to access the database
$user = "localhost";
// The password to access the database
$pass = "password";
// Name of the database
$db = "web111-commb";

Is this set up right? I forgot what the username needed to be would it be web111-commb or local host?

[Bennett 🚀]

// MySQL server location ex. (mysql.example.com)
$host = "localhost";
// The user name to access the database
$user = "admin";
// The password to access the database
$pass = "admin1";
// Name of the database
$db = "database name here";

[Luke]

My localhost username is root.

[Michael]

Dec 15, 2009 13:53:09 GMT -8 @gfx25 said:

// MySQL server location ex. (mysql.example.com)
$host = "localhost";
// The user name to access the database
$user = "localhost";
// The password to access the database
$pass = "password";
// Name of the database
$db = "web111-commb";

Is this set up right? I forgot what the username needed to be would it be web111-commb or local host?

If you're using cPanel and setting this up through that etc, the username & database are both normally username_x/y/z

*where username = your cPanel username
*where x/y/z = username or database

Dec 15, 2009 15:10:04 GMT -8 Luke said:

My localhost username is root.

Then you are a fool

[Luke]

How so Michael?'



It's root on my development server. I know its recommended to create a new user, but I'm lazy... lol

[Michael]

Anyone wanting to hack in, will try the root username first, if they have the username, that's one job less for them to try to get.

However, otherwise, they'd have to work out username, cPanel username, and then password.

[Luke]

Dec 15, 2009 18:16:05 GMT -8 Michael said:

Anyone wanting to hack in, will try the root username first, if they have the username, that's one job less for them to try to get.

However, otherwise, they'd have to work out username, cPanel username, and then password.

Ehhh... It's my development server. Plus root is accessible on any unix system.

[Michael]

Dec 15, 2009 18:18:54 GMT -8 Luke said:

Dec 15, 2009 18:16:05 GMT -8 Michael said:

Anyone wanting to hack in, will try the root username first, if they have the username, that's one job less for them to try to get.

However, otherwise, they'd have to work out username, cPanel username, and then password.

Ehhh... It's my development server. Plus root is accessible on any unix system.

As far as I know, if you're on a shared server, the root is locked down considerably.

[gfx25]

Most of the time everyone uses localhost though cant some use their own ip.

[Bennett 🚀]

Michael, just so you know, that is the real thing if you don't have phpMyAdmin or whatever you use..

[Michael]

Dec 17, 2009 19:53:26 GMT -8 Bennett 🚀 said:

Michael, just so you know, that is the real thing if you don't have phpMyAdmin or whatever you use..

Not at all, it's always advised that you don't use the root account. Always!

[Bennett 🚀]

Hmm.. I've used the root account a couple times, no one hacked in

[Luke]

Like Michael said, it's recommended not required.

[Michael]

Dec 18, 2009 14:34:23 GMT -8 Bennett 🚀 said:

Hmm.. I've used the root account a couple times, no one hacked in

That's 'cause no one knows who you are. Do it, and become famous, then you'll be buggered.

[Charles Stover]

IDK, as long as root has an epic password. If you aren't going to use root, be sure to delete the root account. It's pointless to not use root if root still exists for a hacker to attempt to gain access into.