[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [cobalt-users] osCommerce on Raq550



> When I tried to configure the osCommerce on my RaQ550, the following 
> message appeared.
> 
> 
> Warning: Can't connect to local MySQL server through socket '/tmp/
> mysql.sock' (2) in /usr/sausalito/ui/web/oscommerce/vsite.php 
> on line 84
> 
> Warning: MySQL Connection Failed: Can't connect to local MySQL server 
> through socket '/tmp/mysql.sock' (2) in /usr/sausalito/ui/web/
> oscommerce/vsite.php on line 84
> Could not connect MySQL - Bad User Name or Password!

1. Attempt a command line connect as root to MySQL 
2. If you can connect to MySQL as root and create db users then you've
probably mistyped the db user that you
   want osc to connect as. If you've never connected to MySQL and don't
have any db's setup or admined then you'll
   want to spend a little time getting to know MySQL before going on to
osc. 
3. Alternatives to try: In the place where osc asks for the MySQL
address try these seperately of course:

   localhost
   the Raq's IP address

   Try the above with a blank password first and the user root. If it
connects then you need to makes sure your 
   MySQL root user has a new password set and you're not going to want
to run osc with the user root. Create a  site user for it. 

4. If you're new to MySQL I recommend using the open-source Windows GUI
tool MySQLFront for admin work. Unfortunately development was halted at
the 2.5 version. There is though an active discussion board for it here:
http://mysqlfront.venturemedia.de/ and they have the 2.5 version
available for download. It doesn't run on the server but on your Windows
workstation and let's you manage the entire MySQL database including
setting up users and dbs for virtual sites. 

Tony