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.