X-Forums

Computer, Games, and Technology

having a problem installing WOTLK 3.0.9(9551) Mangos 7308 w/Full database

4 posts

  1. chrono32

    New Member
    Joined: Feb '09
    Posts: 3

    I have a problem installing this..

    Ok so at the beginning,

    When I run the sql dump in SLQyog for realmd

    I get a error..

    This
    ---------------------------------------------------------------
    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 15:46:29
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 15:47:38
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 15:49:20
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 15:50:52
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 15:52:18
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

    Query:
    /*!40103 SET TIME_ZONE='+00:00' */

    Error occured at:2009-02-24 16:13:51
    Line no.:12
    Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
    --------------------------------------------------------------------------------------------------
    And wont finish

    And I get the same error when I run the charcter.sql..

    So I tried to run realmd
    and I get

    -------------------------------------------
    Using Configuration file realmd.conf.
    Database: 127.0.0.1;3306;root;mangos;realmd
    Could not connect to MYSQL Database at 127.0.0.1: Access denied for user 'root'@'localhost'
    <using password: YES>

    Cannot connect to database

    Mangos.conf
    gives me tons of sql table errors

    and says

    This application has requested the Runtime to terminate it in a unusual way...

    So what can I do???? Can it be fixed??

    Thanks for any help...

    I have some knowlege in this but im still a total newb... Is it something Im not doing??
    Do I need to update the time in sql?(How?)

    I made the database
    (mangos.sql etc..)
    In fact, mangos.sql was the only thing that ran correctly and finished...
    realm.sql
    character.sql
    gives me the above error...

    Thanks for any help.. Im really excited about making my own server.. But I always seem to run into a wall..

    Can I get my server up?? How do I fix this...
    I have trillion..(all the im in one)

    My aim is slvrdrgn109
    yahoo is silverdrag24@yahoo.com
    which is the same for msn....

    If thats easier....

    Thanks and have fun :)

    Posted 1 year ago » Permalink

  2. wrath

    Regular
    Joined: Feb '09
    Posts: 41

    Did you make any changes in your mangosd.conf file and your realmd.conf file? If so what did you change? make sure the only change you first want to make is the minimum. Like make sure you change the useranme and password in the conf files to what you used for your SQL database. Like mine is root and password is mypassword. Access denied in your SQl means that the database is not connecting correctly. By chance did you start over in your install with mysql? If so you probably did not get rid of all the excess before you reinstalled. Make sure from a fresh install of mysql that you import the sql files that pryd has given us to download. It should be in full entirety. The link to his mangos install is at http://prydevserver.dyndns.org/forum/. Let me know if this is helpful. Thanks wrath

    Posted 1 year ago » Permalink

  3. wrath

    Regular
    Joined: Feb '09
    Posts: 41

    Actually try this link instead of the one above http://www.mediafire.com/?yvzzyy2hmxh

    Posted 1 year ago » Permalink

  4. sanityimpaired

    Member
    Joined: Feb '09
    Posts: 21

    Cross-posted from my response to the same question in the server post:
    I had a similar problem after I emptied out my mysql database before installing a new mangos database. The problem is that there is a mysql database which is put in on install that I deleted as well, which mysql uses for a wide variety of things.

    Try running the Server Instance Config Wizard again and see if that replaces the mysql database. If it doesn't, you'll probably have to uninstall and reinstall mysql.

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

  • Started 1 year ago by chrono32
  • Latest reply from sanityimpaired

Tags

Gaming

Discuss about PC Games, Console Games or Emulation here

408 Topics – 2,316 Posts