Users Are Missing

[WyleySam]

When I try to make a new connection to to a server I'm getting the following error message:

Error No. 1045

Access denied for user 'neilswar'@'98.193.92.228' (using password: YES)

When I connect to an existing connection on a different server and try to restore a database I'm getting the errors below. When I try to edit users there are none.

Can anyone help???

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 09:43:49

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 09:48:08

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 09:48:14

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 09:53:54

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 10:22:27

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 12:36:18

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 17:17:59

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

Query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/`HousingDirect` /*!40100 DEFAULT CHARACTER SET latin1 */

Error occured at:2010-02-11 17:29:29

Line no.:15

Error Code: 1044 – Access denied for user 'fischer_tester'@'%' to database 'HousingDirect'

[peterlaursen]

does this help:

http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

“Alternatively, on any platform, you can set the new password using the mysql client (or any client like SQLyog – my addition)… stop mysqld and restart it with the –skip-grant-tables option.”

Now you can connect without password, add/edit users (with SQLyog or whatever). Now again start server normally.  But you will need privileges to stop and start MySQL of course.

[WyleySam]

'peterlaursen' wrote on '12:

does this help:

http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

“Alternatively, on any platform, you can set the new password using the mysql client (or any client like SQLyog – my addition)… stop mysqld and restart it with the –skip-grant-tables option.”

Now you can connect without password, add/edit users (with SQLyog or whatever). Now again start server normally.  But you will need privileges to stop and start MySQL of course.

[WyleySam]

No this will not help. I do not have access to other online servers.

The server folks found and fixed some problem. I can now connect, add new connections, and restore databases.

But, SQLyog is still not showing any users!!!

[Author]

Posts