Crap. The list won't let me send the graphic through, and I can't host it anywhere ATM. When I run winmysqladmin.exe it comes up with a gui showing that it's version 1.4 and that's where it asks for a user/pass and says it's creating a my.ini
---------- Forwarded message ---------- From: Bai Shen <[EMAIL PROTECTED]> Date: Tue, Dec 2, 2008 at 10:25 AM Subject: Re: Updating from MySQL 4.0.12 to 5.0.67 Community To: mysql@lists.mysql.com But I didn't create any privileges in the old system. That's where I'm confused. When I install 4, I just click Next, accepting all of the defualts. Then I run winmysqladmin.exe(I can't connect to the db until I do). When I do this I get the screen shown in the attached screeenshot. Then I run mysql.exe and I can create the new database. When I install 5, I accepted all of the defaults except for setting a security password for root(since I didn't do that with 4). I don't have a winmysqladmin.exe to run, and mysqladmin.exe just quits on me. When I run mysql.exe and attempt to create a new database exactly as I did in 4, it gives me the error I mentioned in my original post. So, AFAIK, I'm not setting any privileges. I'm not sure how the admin user in the gui plays into it as I don't provide any login info when I run mysql.exe with 4 or 5. On Tue, Dec 2, 2008 at 1:26 AM, Chandru <[EMAIL PROTECTED]> wrote: > Hi Bai, > > In case you want the privileges of the old system, please take a backup of > the mysql database as inserts and reimport the same in the upgraded server. > If you want a new admin user to be created, then > please check the below page for the syntax: > http://dev.mysql.com/doc/refman/5.0/en/grant.html > > > Regards, > Chandru > www.mafiree.com > On Tue, Dec 2, 2008 at 3:48 AM, Claudio Nanni <[EMAIL PROTECTED]>wrote: > >> Hi Bai, >> I think the best option is to read carefully the installation guide, >> there are some post installation steps to set up initial privileges, >> and everything is explained quite well. >> After that if you still have problems please provide more informations on >> platform and other points >> like the steps and commands you issue and the output you get, >> so you 'help' others to help you, the more you are precise, the more you >> get help. >> >> Sincerely, >> >> Claudio >> >> >> Bai Shen wrote: >> >>> I currently have an application that runs on MySQL 4.0.12. I'd like to >>> update it to the newest version of MySQL so I can have multiple >>> applications >>> using the one database. However, I'm running into some permissions >>> problems. >>> >>> When I install MySQL 4.0.12 I set up an administrator user. Then I run >>> mysql.exe and I'm able to create a new database for the application. I >>> don't log in or anything like that. >>> >>> Now I've stood up MySQL 5.0.67 on another machine. I've recreated the >>> same >>> administrator user, but I'm not sure how to give them the priveleges, >>> since >>> I didn't do anything like that with the older version. And when I try to >>> create the database using mysql.exe I get the following error. >>> >>> ERROR 1044 (42000): Access denied for user ''@'localhost' to database >>> 'newdb' >>> >>> So I'm assuming that my permissions aren't setup correctly, but I'm not >>> sure >>> what I need to change. 5.0.67 seems to handle the administration fairly >>> differently than 4.0.12. Also, I'm not running the newer version as a >>> service. I don't think that would effect things, but I figured I should >>> mention it. >>> >>> TIA. >>> >>> Bai Shen >>> >>> >>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> >