| 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 |
|
|
|
Networking & Security
