Firstly when installing MySQL server you will be prompted for password. Usually the default user is named root and I usually give him a password "root" but you can place your own. My recommendation is to create new user on MySQL and use the new one with php development. But its up to you (you can use phpMyAdmin or MySQL WB for this).
Ok so next thing is to get up and running phpMyAdmin. By default It is not configured ad running so we will do this:
Open terminal and run this:
sudo gedit /etc/apache2/apache2.conf when the apache2.conf is oppened got to the bottom of the page and add this line:
Include /etc/phpmyadmin/apache.conf
After this run
sudo /etc/init.d/apache2 restartto restart the apache. Now open firefox and type the address http://127.0.0.1/phpmyadmin. The login form should appear. Enter the username and password for the root user and you will enter the world of MySQL database server. The next thing to configure is MySQL WB.If you have already installed MySQL WB we will set up a basic conection to our mysql server. Open MySQL WB and click new connection. New dialog windows should open. Leave all settings to default and type in the connection name. In my cas i will name it mysql. Also it is helpful to store the root's password in key chain for future use. So press the store in key chain and enter the roots password. This will remember the password so you will not have to reenter it again. That's it, press Test connection. If you get that connection parameters are good than your conn is good and ready to be used. Press ok. New windows will open and you will see the existing databases on the left panel.
I was extremely happy to locate this website. I wanted to thank you with regard to this terrific read!! I certainly appreciated every little bit of it.
ReplyDeleteEssay Writing
Mmm I am glad to hear that :)
ReplyDeleteI update my blog several times in a week. I try to be thorough. You can suggest here some topics if you like covered. I would be glad to make articles on them.