Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: SoftGil on October 23, 2004, 08:57:53 PM

Title: MySQL in SME Server
Post by: SoftGil on October 23, 2004, 08:57:53 PM

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

Title: MySQL in SME Server
Post by: Mumm-Ra on October 23, 2004, 11:00:46 PM

mysql can host many databases, each with a different name.
The best and easiest way to find out details of your mysql installation is to install phpmyadmin.  There is a contrib that you can install, then you view your databases over the web interface.
To access mysql on a sme server remotly you'll need to specifically allow remote connections as by default you can only connect on the localhost.  Use ssh to connect to your server then run any command locally

Title: MySQL in SME Server
Post by: adolfas on October 27, 2004, 01:36:42 PM

http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-11.noarch.rpm

good luck!  :-)

Title: Re: MySQL in SME Server
Post by: hgomez on October 27, 2004, 04:00:43 PM

Quote from: "SoftGil"

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

Hi my friend, maybe you are on the rightway, but here is my experience:
in order to access mysql remotly you must rebuild /etc/my.cnf,
1.-
mkdir -p /etc/e-smith/templates-custom/etc/my.cnf
2.-
cp /etc/e-smith/templates/etc/my.cnf/* /etc/e-smith/templates-custom/etc/my.cnf
3.-
cd /etc/e-smith/templates-custom/etc/my.cnf
4.-
pico 005mysqld
add this line:
set-variable=thread_stack=256k
under [mysqld] line and Save.
5.-
/sbin/e-smith/expand-template /etc/my.cnf
6.-
cd /etc/rc.d/init.d
7.-
 ./mysqld stop
 ./mysqld start
8.-
write mysql and press intro
9.-
GRANT ALL ON *.* to jdoe IDENTIFIED BY 'johndoe';
10.-
now from every where you can access to mysql:
from windows: mysql -hYourSmithIP -ujdoe -pjohndoe

that is all, hope it help you.

Title: Re: MySQL in SME Server
Post by: hgomez on October 27, 2004, 04:04:17 PM

Quote from: "SoftGil"

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

AHHH, when you get inside mysql server, you have this very simple commands:
show databases;
show tables;
use "Databasename";
select * from tables;

Bye.