Author Topic: Looking good  (Read 2406 times)

fictionaldamo

  • Posts: 10
    • View Profile
    • http://www.prudentview.com
Looking good
« on: December 09, 2004, 08:24:25 am »
I believe I can use this hosting space but I have a few silly questions.

For the following:

$sqlhost = 'localhost';

$sqluser = 'YOUR_USERNAME';
$sqlpass = 'YOUR_PASSWORD';
$sqldb = 'YOUR_DATABASE';

do I just use my yahoo id and password and make up a name for the data base or do I need the information from yahoo?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL setup
« Reply #1 on: December 09, 2004, 10:40:45 am »
You will either be able to configure your MySQL databases, usernames, and passwords in your hosting control panel or you will have to contact your host for availability of the feature and your access information.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

fictionaldamo

  • Posts: 10
    • View Profile
    • http://www.prudentview.com
Getting further
« Reply #2 on: December 09, 2004, 11:25:22 am »
I upgraded so that I could use mysql and gave it the name and password of <snip> and <snip> and the database name is mysql. When I type in the url http://<snip>/mail I get the following error message.

Could not connect to MySQL, host / user / pass = localhost / <snip> / <snip>
MySQL Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

I am not quite sure what I am doing wrong

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL setup
« Reply #3 on: December 09, 2004, 11:55:07 am »
You should try to censor your sensitive information in this forum.  I have edited your post and changed the subject to be of more use to searchers.

If the username, password, and database information is correct, perhaps you need to change the "localhost" variable to something else.

$sqlhost = 'localhost';

Does your host say anything about the MySQL server hostname to connect to?
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

fictionaldamo

  • Posts: 10
    • View Profile
    • http://www.prudentview.com
mysql....
« Reply #4 on: December 09, 2004, 01:24:24 pm »
This is the only help they offer:

If you have not assigned a user name and password to your database, you must do so before you can access your database. Your Yahoo! ID and password will not automatically work.

Once a user name and password are created, you can access your database through any PHP script running on your account. Users with intensive database needs may choose to install phpMySQL, a powerful database administration tool. However, you can create any custom PHP scripts to access your database. Below are a few lines of PHP code that show you how to access your database:

<?php
   $link = mysql_connect("mysql", "USERNAME", "PASSWORD");
   mysql_select_db("DATABASE");

   $query = "SELECT * FROM TABLE";
   $result = mysql_query($query);

   while ($line = mysql_fetch_array($result))
   {
      foreach ($line as $value)
       {
         print "$value\n";
      }
   }

    mysql_close($link);
?>

Of course, you must replace USERNAME and PASSWORD with the user name and password that you have created for your database. You must also replace TABLE and DATABASE with the valid table and database names from your database. The address of the MySQL database server is just "mysql" -- a port number is not necessary.

fictionaldamo

  • Posts: 10
    • View Profile
    • http://www.prudentview.com
getting further
« Reply #5 on: December 09, 2004, 02:18:35 pm »
Now I at least got to the install window by changing localhost to mysql, but now when I type in install I get this message:

Creating config database table lm_config - **Error creating lm_config! Access denied for user: 'randomlooks@localhost' to database 'mysql'
Is the database login information in CONFIG.PHP correct? Did you already run install?

I am getting there but not yet.

fictionaldamo

  • Posts: 10
    • View Profile
    • http://www.prudentview.com
I did it....
« Reply #6 on: December 09, 2004, 02:32:26 pm »
I can't believe it but i did it. I am fired up and working with the system now. If anyone has Yahoo and needs help I am the man.....

Thanks ListMail for all of your help.

Damian

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
MySQL setup
« Reply #7 on: December 09, 2004, 02:56:56 pm »
I'm glad to hear you figured it out.  Please post future questions in a new thread.

Thanks!
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting