New user's registration have been closed due to high spamming and low trafic on this forum. Please contact forum admins directly if you need an account. Thanks !

mysql primer

Got problems with your B2 or B3? Share and get helped!
Post Reply
zander
Posts: 141
Joined: 01 Jan 2009, 23:16
Location: las vegas, nv, usa
Contact:

mysql primer

Post by zander »

hi,

can someone point me to a primer on mysql please? i need to setup mysql to use wordpress on bubba.

is mysql already setup on bubba?

please advise,

thank you.
~alonzo...
HeSitated
Posts: 30
Joined: 26 Jun 2009, 12:36
Location: Ede, The Netherlands

Re: mysql primer

Post by HeSitated »

Log in through SSH and execute:

Code: Select all

ps aux|grep mysql
What does it say?
asparak
Posts: 173
Joined: 08 Jun 2009, 07:38

Re: mysql primer

Post by asparak »

MySQL is installed by default. Things like squeezecenter and Album use it
Kiff
Posts: 48
Joined: 08 Feb 2010, 04:09
Location: Norway
Contact:

Re: mysql primer

Post by Kiff »

log in with "mysql -u root" (the root password is empty be default)

http://www.webdevelopersnotes.com/tutor ... abase.php3
zander
Posts: 141
Joined: 01 Jan 2009, 23:16
Location: las vegas, nv, usa
Contact:

Re: mysql primer

Post by zander »

HeSitated wrote:Log in through SSH and execute:

Code: Select all

ps aux|grep mysql
What does it say?

bubba:/home/af# ps aux|grep mysql
root 2068 0.0 0.5 3460 1532 ? S 2009 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 2107 0.3 14.3 130188 36876 ? Sl 2009 574:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 2108 0.0 0.2 1784 584 ? S 2009 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 31543 0.0 0.3 3088 804 pts/0 S+ 15:16 0:00 grep mysql
bubba:/home/af#
~alonzo...
Binkem
Posts: 388
Joined: 10 Jul 2008, 02:26

Re: mysql primer

Post by Binkem »

You might want to install PHPmyadmin

http://forum.excito.net/viewtopic.php?f ... dmin#p8976

This makes using PHP a lot easier if you're not a linux wizard.
HeSitated
Posts: 30
Joined: 26 Jun 2009, 12:36
Location: Ede, The Netherlands

Re: mysql primer

Post by HeSitated »

zander wrote:

Code: Select all

ps aux|grep mysql
This lists all running processes with the word mysql in it...
zander wrote: mysql 2107 0.3 14.3 130188 36876 ? Sl 2009 574:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
So mysql is running on your B2. :D
Post Reply