Question: |
Previously, it was possible to connect to the database remotely, but now it`s all gone. Restore, please. Checked on the website izhjob.ru |
Answer: |
Hello. from what ip you connect? |
Question: |
IP |
Answer: |
added the IP to trusted. |
Question: |
works |
Answer: |
OK
|
Question: |
now again disconnected. Issued first message mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(`your_existing_password`). This will store a new, and more secure hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf fileА now Host `IP` is blocked because of many connection errors; unblock with `mysqladmin flush-hosts` |
Answer: |
what steps have you performed? |
Question: |
launched a php script which loads the data into the database |
Answer: |
the error says Host `IP` is blocked because of many connection errors; how is configured your script? |
Question: |
Cm. hosting /public_html/loader/loader.php |
Answer: |
in the script there is no connection settings to the database |
Question: |
here the parameters /public_html/application/configsЯ don`t understand what`s the script. |
Answer: |
you specify the config is configured to connect to a local database. Not remote to what base and how do you connect? read the error and you`ll see what does a script. |
Question: |
When you connect remotely worth it настройкаresources.db.params.host=izhjob.ru |
Answer: |
where? what server? you gave links to local scripts your script creates a lot of errors when connecting many connection errors |
Question: |
is on my computer. local script is a copy. |
Answer: |
give the connection settings you are using. |
Question: |
resources.db.params.host=izhjob.ruresources.db.params.dbname=trurl_joblistresources.db.params.username=trurl_joblistresources.db.params.password=Iu9ckTSr8vTq |
Answer: |
have you checked the password? base trurl_joblist and the user trurl_joblist present |
Question: |
Yes, checked the password. not swear for a password, and after five attempts connect disables access |
Answer: |
what version of mysql and php do you use? |
Question: |
I can`t remember now. the computer does not have this at hand. can only in the evening to see. |
Answer: |
please check and report in the ticket |
Question: |
Version PHP 5.3.8 (cli) (built: Aug 23 2011 11:50:20)MySQL is not used in this client. Inside the PHP version of the libraries to work with MySQL to the PHP. |
Answer: |
recreate the database user and change the password. |