34 users online (0 members and 34 guests)  

Thread: my sql


  Results 1 to 15 of 15
  1. #1
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58

    my sql

    ok i read all install guides and everything as most of you know by know all i need is a little push and it sends me on my way so after reading the install guides and everything else it says stop at my sql and i don't know what that is or how to create it i know for a fact my host has that but i need some advice on how to create a my sql database so i can get my fourm alive an kickin thanks!!

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    In theory, the install scripts do most of the work for you.

    However, you will need -

    • Database Server name (prob localhost)
    • Database name (your host should have/will tell you this)
    • Database user name (same as above)
    • Database Password (same as above)


    Knowing for sure that your host supplies these tells me you probably have already been sent most if not all of this info. If not, contact your host. Good luck.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58

    thanks

    thanks so much ur number 1 buddy!

  4. #4
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58

    this is what they said

    >> You can create new database in your Plesk control panel. The same is true for username and password. Use localhost as your database server. thats what they said i look throught it and i still don't know what there talking about any advice

  5. #5
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Log into your control panel. Its in there somewhere.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  6. #6
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58

    ok

    allright i found it but what do i name it

  7. #7
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    What do you fancy

    name it in my honour , call it 'git'

    You can name it whatever you wish. Pay attention to what it says after, sometimes they prefix the db name. For instance, on my host, if I make a database called 'badger' with username of 'stoat', the db ends up called 'somepeop_badger' and the user name is 'stoat@somepeople.net' so pay attention and you will be fine.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  8. #8
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58
    ok this is getting really frustrating i get this when i do everything the installiation guide says i just don't under stand what i am doin wrong Warning: Host 'host1.esphinx1.net' is not allowed to connect to this MySQL server in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 48

    Warning: MySQL Connection Failed: Host 'host1.esphinx1.net' is not allowed to connect to this MySQL server in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 48

    Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 330

    Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 331
    phpBB : Critical Error

    Could not connect to the database

    ???? anyone know because i sure don't i would be willin to pay to get some one to set this fourm up

  9. #9
    sonofmidi's Avatar

    Status
    Offline
    Join Date
    Jan 2001
    Location
    NC, USA
    Posts
    75
    Hmm, are you trying to connect to a remote mysql server?

  10. #10
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58
    no i am using the install phpbb i am following instructions

  11. #11
    sonofmidi's Avatar

    Status
    Offline
    Join Date
    Jan 2001
    Location
    NC, USA
    Posts
    75
    are you entering 'localhost' as the host?

  12. #12
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58
    no but that fixed it thanks so much to all of you guys who help me out thanks thanks thanks

  13. #13
    sonofmidi's Avatar

    Status
    Offline
    Join Date
    Jan 2001
    Location
    NC, USA
    Posts
    75
    Glad you have it working. Not to bust your b*lls, but, Quietdean's first post stated to try localhost as well as the docs with the phpbb stated localhost as the probable server. Could have saved yourself some grief.

  14. #14
    wsp42005's Avatar
    Junior Member

    Status
    Offline
    Join Date
    Apr 2003
    Posts
    58
    haha yeah i didn't really know what localhost meant i am a little newbish i am all good with html and flash but php kills me

  15. #15
    christodd's Avatar
    New User

    Status
    Offline
    Join Date
    Oct 2003
    Location
    Tacoma, Washington
    Posts
    20
    Have you run the Setup program ? Aparently, if you go to http://yourdomain.com/admin you'll have an admin control panel, and there should be a Setup program.

    It looks like you're trying to use a database server that is not on your server.

    If you have run through the setup, you may need to modify the MySQL server permissions - this requires that you can access the MySQL server somehow. As long as you can get a SQL prompt (if you are not the SQL database admin, you will need them to do this) and give yourself permission :

    use mysql;
    insert into users('yourserver.com','username',PASSWORD('password'),'Y','Y','Y','Y','Y','Y','Y','N','N','N','N','N','N');
    flush privileges;

    That should give you access.



    Chris
    Last edited by HTML; 10-31-2003 at 05:08 PM.



Tags for this Thread