How do I encrypt my password?

[socia139]

So I can get the mysql_connection to work?

 

[essellar]

You don't. Or, rather, if you do, then you also need to keep your encryption key in plain text right alongside the encrypted password, along with the algorithm (and initialization vector, etc.), so the net effect is that you've made things slower without actually accomplishing anything. You can store your password in a configuration file that lives outside of your public_html directory, where your script can get at it, but web users can't.

Please note that the mysql_xxx stuff is deprecated in the current version of PHP as well; you will need to use mysqli_xxx or PDO to avoid problems.

 

[socia139]

Here's the problem:
session_name('SOCIALP_SESSID');
$connection = mysql_connect("localhost","socia139_main","mypassword") or die("Sorry we have an overload with users!");
mysql_select_db("socia139_main");

I have my password as my panel password but it gives me an error like Acces Denied: error connecting to...

 

[essellar]

You need to use the password that you gave to your database user, not your cPanel password.

 

[socia139]

Is there a way I can find out that password?

 

[descalzo]

Go to cPanel
mySQL Databases (where you created the DB)
Create a user, writing down the password
Add user to DB, giving ALL PRIVILIGES

Also, use mysqli_ or PDO. mysql_ is deprecated as of PHP 5.5 and will eventually be removed from PHP.

 

[socia139]

I can't it gives me no options

 

[descalzo]

I can't it gives me no options

1. Do not use xHosting Basic
2. Are you ADDING the user to the database? And you do not get an options page when you try to add it?

 

[socia139]

I did but I still get this error:

Sociallimiteds.x10.mx

 

[essellar]

The error I'm seeing indicates that the connection pool (the number of active database connections from all users) is exhausted, not that the password isn't working.

 

[leafypiggy]

@essellar No, that's from his code. It's a password issue.