[Question] MSQL - 42000 Access Denied

Last post 02-23-2010 3:16 PM by Andrey Severtokov. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

02-05-2010 10:42 AM

yakdag
Joined on 02-05-2010
Posts 1

[Question] MSQL - 42000 Access Denied

Reply Contact

Hello,

I'm hanging around with myslq at my laptop.

Tried create a database first. Then created user, and tried to edit database for assigning this user. And I have this error :

------

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'UPDATE' task on 'yakdag_wpdb' SQL_DATABASE ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> #42000Access denied for user 'root'@'%' to database 'yakdag_wpdb'
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

-----

My first database path configuration was like 10.0.1.200,3309 and this error caused.
After the changing database path as localhost,3309 it worked well.

Is it caused by remote license? or is it a bug? As i read in this forum, many mates have this problem but there is no any proper answer from company.

Thanks.

02-09-2010 2:15 AM In reply to

Rubal
Joined on 03-16-2006
India
Posts 838

Re: [Question] MSQL - 42000 Access Denied

Reply Contact

I believe Issue seems to be with the way root user is setup. Try to setup root @ % account again with full rights.

Rubal Jain // Email - Rubal @ Rubal [dot] Net

Windows Server Setup, Configuration, Troubleshooting, Basic Security & Hardening
DotNetPanel - Helm Control Panel Setup, Installation, Configuration, Troubleshooting

Authorised DNP Reseller. Get 20% Discount on all DNP Licenses.
Authorised SmarterTools, Declude, SimpleDNS (JHSoft), Gene6 FTP, Helicon, Kayako, Icewarp Merak, MailEnable, Deerfield Reseller.

DotNetPanel & SmarterTools Monthly Leased Licenses available.

DotNetPanel Professional Server setup includes installation of PHP, Perl, Python, ASP.Net Frameworks, SQL Express, MySQL, SmarterMail, Stats etc and complete integration with control panel just $199/server. Contact for further details.

02-23-2010 3:16 PM In reply to

Andrey Severtokov
Joined on 11-23-2007
Posts 231

Re: [Question] MSQL - 42000 Access Denied

Reply Contact

Here is workaround to avoid this error.

Run the following script from the command line: “C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe” –uroot –ppassword_goes_here

2. As soon as you’ll see the guest prompt, enter the following sql command: grant all on *.* to 'root'@'%' identified by 'password_goes_here' with grant option;

3. You should see a message saying the query is ok.

4. Then restart MySQL Windows service

Best regards,
Andrey Severtokov
DotNetPanel Software - Professionally developed software for hosting businesses

Page 1 of 1 (3 items)

Dotnetpanel Forums