Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2011-04-21 14:15:05

yellowmultimedia
New Member
Registered: 2011-04-21
Posts: 4

connecting to mysql

I’m having a hard time with the setup.

I’m not sure where to write in the path to my actual database.

From what I understand

MySQL login: ‘yellowmultimedia’
MySQL password: ‘****’
MySql server: ‘localhost’
MySQL database: ‘tpsudbury’
Table prefix: txp_ (there will be multiple installations)

Now the obvious issue is how does it know where to connect.. example my database is located tpsudbury.mydomain.com where do i put that in so it can actually connect?

Offline

#2 2011-04-21 14:45:33

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: connecting to mysql

yellowmultimedia wrote:

Now the obvious issue is how does it know where to connect.. example my database is located tpsudbury.mydomain.com where do i put that in so it can actually connect?

You can set the location of the MySQL server with the MySQL server setting. Usually you need to change the setting only when MySQL is hosted on different server system than the web server.

Offline

#3 2011-04-21 19:29:32

yellowmultimedia
New Member
Registered: 2011-04-21
Posts: 4

Re: connecting to mysql

ok… then the next question is why wouldn’t it connect. I get these errors

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /home/jasheb1/textpattern.jasonhebert.net/text1/textpattern/setup/index.php on line 208

Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /home/jasheb1/textpattern.jasonhebert.net/text1/textpattern/setup/index.php on line 210
Can’t connect to database

Offline

#4 2011-04-21 20:15:23

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

Re: connecting to mysql

Is it your self maintained or local server? If it is, is MySQL installed, configured and running?

Offline

#5 2011-04-21 21:15:31

yellowmultimedia
New Member
Registered: 2011-04-21
Posts: 4

Re: connecting to mysql

MySQL is working fine. I have both wordpress and joomla installs that are working perfectly.

Offline

#6 2011-04-21 21:19:53

yellowmultimedia
New Member
Registered: 2011-04-21
Posts: 4

Re: connecting to mysql

using different databases of course.

Offline

Board footer

Powered by FluxBB