Print

[kaminari]

I have never used MySQL before in my life. I don't know what the heck a MySQL database is, I don't know what to do, I obviously have no clue where to go. I am a COMPLETE MySQL beginner. I really want to learn how to install this gallery.

I went to the MySQL section on my web host. I made a database called kawaiisugar with a user hann. So on install.php, the information I entered was:

MySQL Host: localhost
MySQL Database Name: kawaiisugar
MySQL Username: hann
MySQL Password: (the password I gave the user hann)
MySQL Table Prefix: cpg132_

I get a message saying:

Could not create a mySQL connection, please check the SQL values entered
MySQL error was : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Does anyone have any idea what is going on??!  :\'( I'm so bad at this... If anyone knows how to help, and can do so in very SIMPLE wordage ... please post. Thanks to anyone who can help...

[Joachim Müller]

erm, are you webhosted or self-hosted. If you are webhosted, you usually can't create a mySQL user (this is something your webhost has to do for you). If you're selfhosted, make sure you have set up the mySQL settings properly, and you have assigned to proper permissions to your mySQL user.

GauGau

[Nibbler]

If you are doing this through cPanel or similar, make sure you have remembered to add the user to the database after you created them.

[kaminari]

Well, the first post I somewhat understand... I have my own domain. As for the second... What the heck is a cpanel?! O___O;;;

[Nibbler]

It is a tool used by many web hosts that has a mysql section and allows you to create mysql users for your databases. Just a guess as to your problem. If it doesn't apply to you then don't worry about it .

[kaminari]

Okay. This is all very confusing. I vaguely understand... In my web panel at my host, dreamhost.com... I went to the MySQL section and made a database called kawaiisugar. I made a used hann and added them to that database... Yet when I try to log in on install.php with that information, it doesn't work... :\

[Nibbler]

Dreamhosts' site talks about setting up an host name for the database, so you may have setup something like mysql.yourdomain.com and use that instead of putting localhost.

[kaminari]

Hooray!!! ^_^ I got it to work... http://kawaii-sugar.org/coppermine

But now arises another bug... ;___; ... Any clue what's wrong with my search? Whenever I search, things go wrong, and I often get a message: ...

Fatal error: Cannot redeclare clean_words() (previously declared in /home/.quaintdryer/hann/kawaii-sugar.org/coppermine/include/search.inc.php:44) in /home/.quaintdryer/hann/kawaii-sugar.org/coppermine/include/search.inc.php on line 44

What does this mean? I opened up search.inc.php and looked. Line 44 is

function clean_words(&$entry, $mb_charset)

Obviously, I'm clueless... Does anyone know what to do? -_-;;; ...

[Joachim Müller]

we have a "one question per thread" policy on this board; in the future, please post unrelated stuff on different threads.
I went to your site and tried searching several times, without any error messages coming up. If you encounter another error message when searching copy the url from the address bar and paste it into your next posting here.

Joachim

[kaminari]

Oh, sorry. I'll post a new thread.