i have Sql problem this is my website http://xfilm.awardspace.com/install.php cant connect to sql server i dont know where is the problem as am newbie in using sql and databases ..i know it may be a simple thing however i cant find the reason uptill now any body can help Guys.... ?
Hi saintwolf, The first thing to check is if MySQL is actually running. Open a terminal window using SSH and once you have logged on type: ps -ef | grep mysql* If all you get as output is 'grep mysql*' then MySQL isn't running and you need to start it. If it is running then look for a line containing '--socket=' . The entry here will tell you where MySQL has created it's unix socket file. Your script is looking for it at /var/run/mysqld/mysqld.sock but it may be in a different place on your server and the install.php script may need changing. HTH
i found this in the company FAQ ( You cannot make connection through socket, please use MySQL settings to establish connection(see above question). it solves my problem which is (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) but still i dont know how to use MySql settings to establish a connection ...how i reach Sql settings shall i have to modify in the sql file or what
Hi there, just to cover the basics, are you using a cPanel host? if so, have a look at the mySQLadmin button within the control panel. you probably want the standard settings for your form like host: localhost and you will probably have to create a database from your cpanel to get the script working. good luck!
am newbie and i dont know and am not familiar with SQL basics ...i copied and pasted the SQL file to a Query window in My Sql i think now i need SSH client (like PuTTY program) to modify MySQL settings to establish a connection because i cant find any settings in the host company control panel ( am using awardspace.com free hosting plan ) i want an exprienced SQL Guy to tell me does really i need SSH client to establish a connection or am forbidden to establish a conection cuz am using a Free hosting plan ....anybody helps ?
i don' know what to say... but don't forget this It's crucial that you don't forget to setup the access rights with CHMOD 777 for the following: - blacklist.txt - censor_words.txt - uploads/ - uploads/avatars - uploads/thumbs - Smarty/templates_c you must chmod them all to 777
You need to make a database for the script and than in "config.php" probably enter in the database name, the user name and the password. So the script can connect to that database you made for the script.. Boulder