Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create localhost database using mysql?

I download mysql installer here:

http://dev.mysql.com/downloads/installer/

And then I downloaded MySql WorkBench.

At workbench's connection configuration I put hostname as "127.0.0.1", port "3306", user: "root", password is empty. I click "test connection" and it gives me this error:

"Can't connect to MySQL server on '127.0.0.1' (10061)"

What am I missing?

like image 915
alansiqueira27 Avatar asked Dec 12 '13 13:12

alansiqueira27


People also ask

How do I run MySQL on localhost?

Go ahead and open MySQL Workbench and let's connect to this new local server. Click on the “New Connection” icon and leave everything default, except the “Connection Name,” here enter localhost . Double click on the new connection and enter the password you created during installation. Voila!

Can MySQL run locally?

On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user.


1 Answers

See here for starting the service and here for how to make it permanent. In short to test it, open a "DOS" terminal with administrator privileges and write:

shell> "C:\Program Files\MySQL\[YOUR MYSQL VERSION PATH]\bin\mysqld"
like image 99
sfotiadis Avatar answered Oct 03 '22 04:10

sfotiadis