Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Rennaissance on January 31, 2005, 06:40:01 PM

Title: How to acces MySQL ?
Post by: Rennaissance on January 31, 2005, 06:40:01 PM

I have read the fine manual of the SME server.(literally every word of it.)

But nothing is mentioned about MySQL.

Apparently it does run on the server, cause PHPINFO.PHP mentioned a "Client API version 3.23.56".

Now : how do I connect to this MySQL ?

As I mentioned before I never worked with Linux. SO I was glad I found the mc (Midnight Commander).

But now how do I access and login to this MySql and perform tasks such as creating databases and tables.

I am familiar working with PHPMyAdmin, but that was under windows. How do I set up PHPMyAdmin with the SME server ???

Please help me , I would like to keep this server !
My partner wants to install MS win2000 server.
But I say I can find out how this SME server works.

Title: Re: How to acces MySQL ?
Post by: raem on February 01, 2005, 05:31:11 AM

Rennaissance

Search the contribs area for the sme phpmyadmin contrib and install it, simple as that.
or...
At the command prompt type mysql
Search web for a mysql commands tutorial, there are plenty around.
type
exit;
to get out of mysql

Title: How to acces MySQL ?
Post by: alejandro on February 01, 2005, 11:16:44 PM

http://no.longer.valid/phpwiki/index.php/phpMyAdmin

Title: Little followup for all who want to install PHPMyAdmin
Post by: Rennaissance on February 03, 2005, 07:47:04 PM

Download the file from the link above.
Then upload it to your server.

Then in the server console
(when rebooting your server login:root, pass: the administrator password)

press : "mc" then find that file you uploaded.

when it is highlighted just ENTER it and with cursor go to "install" in that folder and press ENTER.
then you see it is being installed. . .  wait for 100%. Now you can access PHPMyAdmin as described. . .

(this is for newbies like myself . . . hehehe)