HOW TO SOLVE ERROR #1045

-

HOW TO SOLVE ERROR #1045 for your phpMyAdmin(WAMP/MAMP/XAMPP)

Error #1045 when your root@localhost database user is denied the necessary rights to access the database, or when you provide wrong password. In such cases when you try to access your phpMyAdmin you get the following error” 

#1045 Access Denied for user 'root'@'localhost' (using password: YES).
This tutorial will guide you on the steps to follow in order to solve this problem. This tutorial will assume that you already have your wamserver running.
Step 1. Open MySQL Console. You do this by clicking WAMP icon located at the bottom right of your computer.
 


Hover over MySQL and follow the sub-menu arrow. Click on MySQL Console. 



Skip this part if you have a password already.
To set your MySQL password type:
                   Use MySQL
Then press Enter.
You will see the following:

Step 2. Enter the Provided Commands

 

 


Add the following command so as to set MySQL password, replace "EnterYourPasswordHere" with your preferred password.
Press Enter.
Next flush the privileges by typing:
  FLUSH PRIVILEGES;
Now you can Exit by typing:
   Exit
Press Enter.

Step 3 Edit the config.inc.php File

In this step, we will see how to edit the config.inc.php.
You can access this php script file by going to your Local Server Folder; in our case, we are using WAMP. The WAMP location is C:\wamp. Inside this folder open Apps folder, then PhpMyAdmin folder. There you will find the config.inc.php file.






Use a text editor such as Notepad, Notepad++ or phpEditor to open this file(config.inc.php)
Look for the following line:

$cfg['Servers'][$i]['password'] = 'xxxx'; // MySQL password

NOTEPAD EXAMPLE

Notepad
 PHP EDITOR EXAMPLE


Change the 'xxxx' to the newly chosen password you created in Step #2.
It changed line should look like this:
$cfg['Servers'][$i]['password'] = '123paswd'; // MySQL password
Make sure to set your own password, the one you chose in step 2.
Finally Click Save and close the file.



Comments

Post a Comment

Popular posts from this blog

How to paste image into picturebox from clipboard with VB.Net

-
Image
How to paste image into picturebox from clipboard with VB.Net If you wish to paste an image into a picturebox from clipboard for your VB.Net project, this is what to do: 1. Add a picturebox to your form. 2. Add a button and copy paste the code below.         Private Sub btnPastePic_Click(sender As Object, e As EventArgs) Handles btnPastePic.Click               'If My.Computer.Clipboard.ContainsImage Then         '    PictureBox1.Image = My.Computer.Clipboard.GetImage         'End If         Dim idata As IDataObject = Clipboard.GetDataObject()         If idata.GetDataPresent("System.Drawing.Bitmap") Then             Dim imgObject As Object = idata.GetData("System.Drawing.Bitmap")             If imgObject IsNot Nothing Then                 Dim img As Image = TryCast(imgObject, Image)                 If img IsNot Nothing Then                     PictureBox1.Image = img                 End If             End If         End If    
Read more

CREATING CRYSTAL REPORTS VB.NET 2012 STEP BY STEP - PART 2

-
Image
Creating A New Report In our part one tutorial ,  we saw how to prepare create a new VB.NET project which we will use in creating and displaying our crystal reports. In this part, we will see how to create the Crystal Report inside VB.NET.  1. Under your project name, right-click and select Add then click New Item. Under Reporting, select Crystal Reports. (Remember we started by installing Crystal Reports for VS 2012 . If you missed this step, please refer to this tutorial here )  2. Give your Report a name and click Add. The diagram below shows the four steps to follow in naming the report and adding it. Once you click Add, you will be taken to Crystal Reports Gallery. 3. In the Crystal Reports Gallery select one of the three options; in our case, we will pick option 2 which is As a Blank Report. So select As a Blank Report. Then under Choose an Expert, select Standard. Finally, click OK button.  4. Back now to your workspace. With the report open(th
Read more

How to Create Crystal Report using Visual Studio 2012 Part 1

-
Image
How to Create Crystal Report using Visual Studio This tutorial will focus on creation of Crystal Report using Visual Studio 2012.  To accomplish this you will require to have: Microsoft Visual Studio 2012. MySQL. SAP Crystal Reports version for visual studio 2012.  For the purpose of this tutorial, we will be using VB.Net.   To start create a vb.net project Open visual studio (2012) and create a new project.   Creating a new project  2. Select VB.NET then click on Windows Forms Application.  Give it a name as shown in item 3 in the screenshot below.    Finally click OK.  Now your project is set. You can now start the process of integrating it with Crystal Reports. 3.Right click on the name of your project.  Click Add and then New Item. 4. Add New Item dialog box will appear. Under Common items select Data tehn select Dataset.  Give it a name and click Add as shown below. Selecting Dataset 5. A Dataset Designer comes up.  Right-cli
Read more