MySQL Forums
Forum List  »  Install & Repo

New Install on windows 2008 server
Posted by: Craig Ryan
Date: October 29, 2013 07:34AM

I have attempted to do a new install of mysql on a windows 2008 server but it always fails at the security step - below is the .err file - error Nr. 1045 Access denied for user 'root'@'localhost' (using password: NO) I am adding a password so not sure why it is saying NO? I have firewall disabled but I still went ahead an opened port 3306 but same error??Any help would be greatly apperciated - thank you

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
131029 9:03:33 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131029 9:03:33 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 54 MB
InnoDB: Database physically writes the file full: wait...
131029 9:03:33 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 54 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131029 9:03:33 InnoDB: Started; log sequence number 0 0
131029 9:03:33 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
131029 9:03:33 [Note] Event Scheduler: Loaded 0 events
131029 9:03:33 [Note] D:\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.24-rc-community' socket: '' port: 3306 MySQL Community Server (GPL)
131029 9:03:37 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

Options: ReplyQuote


Subject
Written By
Posted
New Install on windows 2008 server
October 29, 2013 07:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.