Skip to main content

ERROR 1044 (42000): Access denied for user

Unable to import database with user[all permission granted still getting that error] - ERROR 1044 (42000): Access denied for user

Solution :
Note: Before playing wiht any file to your system make backup then only try

1. First of verify the user with which you are trying to export database
2.Check the database, there might be database name defined in the sql so that would problem

lets say you are trying to import database 'xyz.sql' to the test_db <DB name>

then vi xyz.sql

check the top 10 lines, you might see the defined database name already their. So you need to replace that database name with test_db < i mean you db name> .

Possibly, you need to change the older db name with your new db name to which you want to import

3. mysql -u username -p dbname < xyz.sql

Comments

Post a Comment

Popular posts from this blog

upload file type rocket chat #Accepted file upload. Can not send .xlsx

Enabling File format for upload at ROCKET CHAT application/msword   - for .doc application/vnd.openxmlformats-officedocument.wordprocessingml.document   - for .docx application/vnd.ms-excel   - for xls application/vnd.openxmlformats-officedocument.spreadsheetml.sheet   - for .xlsx application/vnd.ms-powerpoint   - for .ppt application/vnd.openxmlformats-officedocument.presentationml.presentation   - for .pptx image/*,audio/*,video/*,application/zip,application/x-rar-compressed,application/pdf,text/plain,application/msword,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
2 comments
Read more

Troubleshooting DRBD #Centos #DRBD

Troubleshooting DRBD  This article presents common DRBD problems and solutions. DRBD (Distributed Replicated Block Device) runs on the master and slave nodes only, and is responsible for mirroring the contents of a partition between master and slave.  Typical problems in DRBD include: A lack of Primary-Secondary connectivity The Secondary operating in standalone mode Both nodes reporting connectivity but neither one in the role of master Both nodes reporting themselves in the role of master Verify the DRBD status The following command is used to verify that DRBD is operating normally on the master and slave nodes. drbd-overview When run on the master node, the output should look like the following: 1:r0/0 Connected Primary/Secondary UpToDate/UpToDate C r----- /mnt/drbd  ... When run on the slave node, the output should look like the following: 1:r0/0 Connected Secondary/Primary UpToDate/UpToDate C r----- The following sections are exampl...
Post a Comment
Read more

How to Add a Static TCP/IP Route to the Windows Routing Table #windows #route #add/delete

How to Add a Static TCP/IP Route to the Windows Routing Table In some specific types of environments, you might find it useful to add a static route to the routing table in Windows. Here’s how to go about it. RELATED:   How to Use Traceroute to Identify Network Problems A routing table dictates where all packets go when they leave a system—whether that system is a physical router or a PC. Most routers—including the one built into your Windows PC—use some form of dynamic routing, where the router is capable of selecting the best place to forward packets based on information it gets from other routers. You can see it at work if you use the  traceroute command  to watch the connections a packet makes as it reaches it’s final destination. Most routers also allow you to add a static route (one that doesn’t get dynamically updated) if you want to always forward certain traffic to a specific router or gateway. Why? Well, most people using Windows in t...
Post a Comment
Read more