JLBN – Setup MySQL Database on WAMP

In this guide for WAMP, we will show you how to install and setup a database account for WAMPSERVER which includes a database, a username and a password. There are too many ways to create a database account, so here we only show one method which is the easiest, simplest, and security, in which a user can ONLY see and manipulate her assigned database.

Note: For different applications and/or users, you should create a new separate database account for each

Note: Even this guide is used for Wampserver, you can apply this method on other wamp package such as Xampp, EasyPHP, so on. Just make sure to select correct file(s) in proper location(s) 😉

[Read more…]

44 thoughts on “JLBN – Setup MySQL Database on WAMP

  • June 17, 2011 at 8:32 pm
    Permalink

    I decided to set up the database to see if that solved my problem but now the error just says

    Starting to parse config file…

    And that’s it. nothing more

    • June 18, 2011 at 6:36 am
      Permalink

      Mackenzie Andersen, are you sure your MySQL working? If yes, make sure you don’t use some reserved words. If no, try to close any Database server and search to delete any php.ini, my.ini, my.conf, or my.cnf file outside wamp folder

  • June 17, 2011 at 12:18 pm
    Permalink

    This is for NICK”s problem.

    I changed the following from true to false. It was not in the instructions but makes sense.

    $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

  • June 17, 2011 at 12:15 pm
    Permalink

    I followed the instructions for setting up a user name and password

    But I get this error. I can’t see any mistakes in line 15

    Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\apps\phpmyadmin3.3.9\config.inc.php on line 15 – which is the user name ‘ root ‘.

    • June 3, 2011 at 5:34 pm
      Permalink

      Phil, just simply follow this guide 😉

  • March 28, 2011 at 2:18 pm
    Permalink

    hi there i need your help seriously i have to submit my project soon and i am getting this error

    Access denied for user ‘user_honey’@’localhost’ (using password: YES)

    tried your link but nothing changed pls help me in this pls

  • February 1, 2011 at 8:22 am
    Permalink

    Thanks for this tutorial. I followed it exactly, but when I try to log in to phpMyAdmin using the Joomla user and pwd, it says:

    #1045 Cannot log in to the MySQL server

    The Joomla installation is also throwing this error. Have missed something?

    Thanks.

    • February 4, 2011 at 9:09 am
      Permalink

      Sajjad, did you try it more than once since it sounds you might have extra letter when created password?

  • May 27, 2010 at 8:12 am
    Permalink

    Hi ,
    I have a stupid doubt but still eager to know if possible. Is it possible to restart our wamp server using php code [i.e by issuing a command or by running a function defined in any dll files or by making any changes in config file] If it is programatically possible pls reply to my mail id..

    • May 27, 2010 at 5:25 pm
      Permalink

      sajith, not directly w/ php codes which can not stop Windows Services but you can create a batch file to stop those services and php file to call that batch file 😉

  • December 12, 2009 at 11:18 pm
    Permalink

    Oh and I agree… You should add to this tutorial by showing us how to use the account information to connect and insert information into a database!

  • December 12, 2009 at 11:15 pm
    Permalink

    I saw your link on the wampserver forums and thought “Oh, here is the answer to my worries!”. Alas, it wasn’t enough lol But regardless thank you for your great and idiot proof tutorials!

  • November 10, 2009 at 12:43 am
    Permalink

    how to encrypt the password in wamp server i installed joomla and jomsocial. login which is used from jomsocial, its encrypt the password, i want to check the same username, and password which is used in the another form.how can i use? how can i encrypt the password? give any answer or reply……… pls….

  • August 17, 2009 at 2:38 am
    Permalink

    I used WAMP to create a site and then uploaded it to my host server. Now I want to create a new project.
    I deleted the old project, downloaded a new version of Joomla! and unpacked it in Wamp/www/
    I got stuck at installation beacause I haven’t created a new database
    I started to follow your tutorial – then side tracked to create a password.
    I did OK until I got to ‘open file config.inc.php – it wouldn’t let me: – asked OPEN or SAVE then kept looping back to OPEN or SAVE every time I clicked OPEN.
    Tried SAVE which went to DOWNLOADS but again wouldn;t let me open from there either.
    I closed WAMP and re-started, but now can’t access phpMyAdmin – Access denied.
    Do I need to uninstall and get a new WAMP download?

  • July 23, 2009 at 3:25 am
    Permalink

    One and half million thanks for the step by step guide. Easy to follow! and certainly I will make my small donation .

    I had like to host my own website on my local computer.
    But have the dilemma to choose in-between local host or getting a remote web host.

    Any one with some ideas on which is the best solution?
    many thanks

    • July 23, 2009 at 4:59 pm
      Permalink

      Veedo, consider 2 factors: money and control.

      When hosting on your own pc/server, you have to pay more money for maintain your own pc, pay more money for electricity usage since your pc/server has to run 24/7 non-stop, and have to pay more for internet services since running server replies on high upload speed which you can’t get in normal residence internet plan, for example, if you have cable internet with 10MB plan, which might be 10MB/512KB, that means 10MB download speed and only 512KB upload speed which is a very slow performance for hosting a web server, so instead paying $20/mth for this plan, you have to upgrade to business internet plan 6MB/6MB that would cost $50/mth while signing up for webhost only cost couple dollars a month such as this webhost and don’t have to spend extra money for pc maintenance and electricity usages either

      On the other hand, you’re in control when hosting on your own pc/server since you can host anything you like as long as it’s not against the law in your country, you can make a change any time you want, and more, you can host other people websites; starting w/ free subdomains then very low cost subdomains for example

      In conclusion, if you don’t want to spend much money and only have some websites, you better get a webhost, but still install wampserver on your pc so you can test or develop web page or web script. However, if you want to control and plan to host, you need to practices and you can’t do it on webhost but have to actually hosting on your own pc/server to gain experiences 😉

  • July 5, 2009 at 11:31 am
    Permalink

    Hi,

    colud you write some guide regarding WAMP and PostgreSQL?

    • July 6, 2009 at 11:29 am
      Permalink

      Ryszard, we will but sorry not at this moment

  • April 4, 2009 at 6:58 am
    Permalink

    Brilliant guides. Have you thought about publishing them as PDFs or ebooks? For a small fee you could help cover some of your costs.

    Just one small point: you could warn people to switch off Skype before running Wamp. I believe that there is a conflict as they both try to use port 80.

    • April 4, 2009 at 8:15 am
      Permalink

      Andy, you can actually use both Wamp and Skypes if you setup Skypes NOT to use default web port as follows:
      Open skype and select Options, then Connection and uncheck “Use port 80 and 443 as alternative”

      Brilliant guides. Have you thought about publishing them as PDFs or ebooks? For a small fee you could help cover some of your costs.

      Sounds interesting and hope you would provide a little more detail, and through our email webmaster[at]jlbn[dot]net if you don’t mind 😉

  • March 26, 2009 at 6:40 pm
    Permalink

    Again clear explanations.

    Just a short question :
    Does that mean that you would recommend to create an administrator account and then as many access accounts to the dB as the database will have customers ?

    In other words, Why not to have only 2 accounts and their privileges (for example, 1 for administration with full access and 1 with a restricted access for the website access to the dB) ?

  • February 13, 2009 at 6:58 pm
    Permalink

    Hello. I am facing the same problem with the guys. I accidentally add a password to phpmyadmin and there is no way to access it. It prompts without asking me for a password. What can I do?? Can you please be more specific in where can I find it your guide?

    Thank you in advance,
    Nick

  • January 31, 2009 at 3:22 pm
    Permalink

    Your step by step tutorials are great, especially for a beginner like me. I also installed Joomla using your tutorials. I created a database and a trial table to see things are working. Unfortunately I was not able to connect to database. I was just seeing a blank page when I tried to do so, was not even able to see “Could not connect to database” written in or die.

    It would be very useful for me and many others like me, if you could include tutorial to create a small table and retrieve and display the results using php page. Maybe a simple query like “Select * from tablename”.

    Also another request would be to include tutorials on how to use Joomla. There are tutorials on web, but not as convincing and procedural as your site.

    Regards
    Amit

    • February 1, 2009 at 10:01 pm
      Permalink

      I created a database and a trial table to see things are working. Unfortunately I was not able to connect to database.

      Follow this guide to setup database
      http://blog.jlbn.net/?p=19

      It would be very useful for me and many others like me, if you could include tutorial to create a small table and retrieve and display the results using php page. Maybe a simple query like “Select * from tablename”.

      We had one, but the static for that page was so low, so we took it out; we might put it back just for you 😉

      Also another request would be to include tutorials on how to use Joomla. There are tutorials on web, but not as convincing and procedural as your site.

      We won’t promise anything but we might put up some basic settings and uses of Joomla soon 😉

Leave a Reply