You are not logged in. Please login or register.


Post new reply

ochiba forum → Support → mysql issues → Post new reply

Post new reply

Compose and post your new reply

You may use: BBCode

All fields with bold label must be completed before the form is submitted.

Required information for guests


Required information

(delete this if you are not)

Topic review (newest first)

11

What kind of server environment are you on? What OS/web server/PHP version/MySQL version, etc

10

tried mysql://dbusername:password@localhost/ochiba with no luck.
though navicat has no issue connecting

9

tried that, and no luck.

8

Hmm, not really since mysql (or any database other than sqlite) is outside the scope of the hardware and more of an individual system configuration matter that will vary with each computer.

You tried the "mysql://dbusername:password@localhost/ochiba" string right?

7

nope... is there any fool proof way to set this up, seeing as i might just be the fool here.

6

Does it work?

5

okay, used navicat to create a new user and set a password, though i gave that user all the same abilities as the root. i am not sure if i am doing any of this right.

4

I think most people would advise against such a setup for an Internet-facing web site given its security problems - you should create a separate user with access only to the ochiba database, for example.

In any case, to mirror how you are connecting via navicat, try "mysql://root@localhost/ochiba" (notice the @ instead of :)

3

well, i have only just installed mysql, and i have navicat up and running. navicat is connected to mysql through root with no password. shouldn't that be what ochiba should connect as as well.
also, i am not 100% that localhost is where it is. but i do not know how to confirm that.

2

Hmm, is "mysql://root:localhost/ochiba" really what you have in your conf.php? If so, it should look more like "mysql://dbusername:password@localhost/ochiba", filling in your database username and password of course.

1

Checking for convert (/usr/bin/convert) ... OK

Checking for identify (/usr/bin/identify) ... OK

Checking permissions on /Library/WebServer/Documents/img ... OK

Checking permissions on /Library/WebServer/Documents/thumbs ... OK

Checking permissions on /tmp/ochiba-cache ...OK

Checking for HTML_Template_IT ...OK

Checking for PEAR::DB ...OK

Checking for database definition ... OK

Checking for database connection ... FAILED - please check connection settings (mysql://root:localhost/ochiba)


this is the error that i keep getting... i think that i have it set up correctly, but seeing as i am new to all this i am not sure.

ochiba forum → Support → mysql issues → Post new reply



Generated in 0.015 seconds (73% PHP - 27% DB) with 9 queries