Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: dann on February 28, 2005, 04:34:56 AM

Title: how to access mysql database
Post by: dann on February 28, 2005, 04:34:56 AM

Hello,

I need help accessing mysql database on my 6.x SME server. Whenever I attempt to access, I get one of several can't access messages.

The following is the first part of my php script.

$link = mysql_connect("localhost", "root", "password")
 or die("Could not connect : " . mysql_error());

If localhost is used with any user with or without a password I get-
Could not connect : Access denied for user: 'root@localhost' (Using password: YES) or (NO without a pw)

If I use the name of my server (homer1) I get-
Could not connect : Host 'homer1.home' is not allowed to connect to this MySQL server.

I don't know where to determine what I'm doing wrong. My ultimate goal is to get Mantis running on my server.

Any help would be appreciated.

Thanks,

Title: do some digging
Post by: gbaird on February 28, 2005, 04:45:59 AM

Do a search for the phpmyadmin rpm and install it

here it is this is as simple as it gets

from your SME server type the following

wget http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-12.noarch.rpm (press enter)

rpm -ivh e-smith-phpmyadmin-2.6.0-12.noarch.rpm  (press enter)


now it is done you can just connect to mysql by using

https://yourservername/phpmyadmin/

just use your admin - login
& your admin password

you will be able to make databases add users very easy

in case you don't know how to install



hope this helps

Title: how to access mysql database
Post by: dann on February 28, 2005, 05:22:39 AM

GBaird,

Actually I did install phpadmin on a previous SME server installation but that did not help me gain access via my own written php files.

I really want to know how to detemine why I can't make a connection, what is wrong and make the necessary corrections.

I will do as you suggested and install phpadmin on this server instalation and see if I gain any new insite.

Thanks.

Title: what do you need to do
Post by: gbaird on February 28, 2005, 05:38:15 AM

Dann

If you are trying to use a php program to access mysql

create the database with phpmyadmin

database = dann

add a user = dann
host = localhost
password = "password"

select the user "dann" and in the

Database-specific privileges select "dann"
giving all Database-specific privileges
by selecting the CHECK ALL link

In your php program your database connection would be

database = dann
login = dann
password = password

should connect

I have done it 100 times

Greg

Title: Good information
Post by: dann on February 28, 2005, 06:16:03 AM

Greg,

Hey, thanks for the additional good information. I am about to install mysqladmin right now. I'll follow your instructions and I'm sure things will work out as you suggest.

Tnx,

Title: Got it to work
Post by: dann on February 28, 2005, 07:50:58 AM

Greg,

I didn't realize it (really forgot) but I already had myphpadmin installed. I downloaded per your instructions and after I tried to install myphpadmin, rpm told me that it was already there. I've changed hardware so many times and new installations of SME, I was lost.

The bottom line is that I am now able to access the original small DB as well as a new one I created with myphpadmin. This is a neet tool although a bit confusing to start with.

Thanks again.

Say, do you know if there is an SME installation package for Mantis?

Title: Mantis install
Post by: gbaird on February 28, 2005, 03:58:24 PM

Dann

Just create an ibay maybe call it bugs or bugreport

un-zip or un-tar mantis in a temp folder and

ftp mantis to your sme server ibay the follow the install instructions

don't forget to enable script exicution on the ibay
and you will have to have a mysql database for it

Greg