View previous topic :: View next topic |
Author |
Message |
ManReal n00b
Joined: 30 Jan 2007 Posts: 10
|
Posted: Tue Feb 06, 2007 1:19 am Post subject: Installing phpBB2 on Box |
|
|
I'm trying to install phpBB2 onto my xbox. I already have apache2 and I have mysql with php support. I placed a forum installation into the appropriate folder. However, upon installation it asks for "Your Database Name: " which I don't know. Is there a command to get the name of your database? |
|
Back to top |
|
|
shickapooka800 Guru
Joined: 05 Dec 2004 Posts: 304 Location: no
|
Posted: Tue Feb 06, 2007 1:25 am Post subject: |
|
|
assuming you set a password on the mysql root account, this is how you look at databases:
Code: |
mysql -p -u root <enter>
##you will be prompted with the mysql prompt after you enter your mysql-root password (not same as root on machine)
mysql> show databases;
##output: current databases on machine
|
search google to find small tutorials on how to set mysql root password, and absic database/user management in mysql. |
|
Back to top |
|
|
ManReal n00b
Joined: 30 Jan 2007 Posts: 10
|
Posted: Tue Feb 06, 2007 1:28 am Post subject: |
|
|
I get the following error any ideas why?
Code: |
Xbox ~ # mysql -p -u root
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
|
|
|
Back to top |
|
|
shickapooka800 Guru
Joined: 05 Dec 2004 Posts: 304 Location: no
|
Posted: Tue Feb 06, 2007 1:35 am Post subject: |
|
|
ManReal wrote: | I get the following error any ideas why?
Code: |
Xbox ~ # mysql -p -u root
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
|
|
mysqld is not running.
try
Code: |
/etc/init.d/mysqld start
|
although this looks like you haven't done anything past emerge mysql, so I would check this out first: http://gentoo-wiki.com/MySQL/Install
check out the stuff on post-install, like setting up passwords and starting the daemon. |
|
Back to top |
|
|
ManReal n00b
Joined: 30 Jan 2007 Posts: 10
|
Posted: Tue Feb 06, 2007 1:53 am Post subject: |
|
|
Xbox ~ # /etc/init.d/mysqld start
-bash: /etc/init.d/mysqld: No such file or directory
--------------------
So thanks for you help. I would have tried installation millions of times if it weren't for you. So i'll try getting mysql to work |
|
Back to top |
|
|
ManReal n00b
Joined: 30 Jan 2007 Posts: 10
|
Posted: Tue Feb 06, 2007 2:06 am Post subject: |
|
|
I installed mysql though.. I remember, is it possible in another location? |
|
Back to top |
|
|
|