Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: oladapopaul - helmikuu 13, 2011, 06:15:55 IP

Otsikko: Problem installing my forum
Kirjoitti: oladapopaul - helmikuu 13, 2011, 06:15:55 IP
This is the error message i keep getting while i was trying to install my smf.Is there anyone that can help me out? Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'myjobski'@'localhost' (using password: YES) in /tmp/cpanel_phpengine.1297637217.287337aVqlvxRlh on line 1641
Access denied for user 'myjobski'@'localhost' (using password: YES)
Otsikko: Re: Problem intalling my forum
Kirjoitti: tumbleweed - helmikuu 13, 2011, 06:21:30 IP
double check and make sure the password that is placed in the settings.php is correct.
Otsikko: Re: Problem intalling my forum
Kirjoitti: JimM - helmikuu 22, 2011, 08:56:24 IP
Welcome to SMF.

Make sure the information you used to create the database user and password, are the same ones you are trying to use when doing the install.
Otsikko: Re: Problem intalling my forum
Kirjoitti: rystan - maaliskuu 05, 2011, 03:23:18 AP
If you control your own mysql server you can quickly add a new user for your database with

mysql -u root -Be "GRANT ALL PRIVILEGES ON databasename.* TO user@host IDENTIFIED BY 'password';FLUSH PRIVILEGES;"

If you need only a basic privileges  replace ALL PRIVILEGES with SELECT, INSERT, DELETE, UPDATE, DROP or whichever privilege you need, seperated by a comma.   This is of course ran at a command prompt/shell.   

ensure that databasename is correct and your host is either the IP of the server hosting the website, its hostname or FQDN.  127.0.0.1 or localhost are acceptable if both your webserver and database reside on the same machine. 

Ensure when you setup that you have put the same IP/hostname in the settings.php or installer as you used adding your user to the permissions table. 

For full information you can visit the following website as it appears you are using Cpanel.

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Create a Database User 
Otsikko: Re: Problem intalling my forum
Kirjoitti: JimM - maaliskuu 05, 2011, 02:53:04 IP
@ oladapopaul - any update on this?  Were you able to complete the install?