my sql user and paswword

Hi ,
I downloaded mysql-5.6.27-winx64.zip and unzipped to a folder.
but not able to connect to it .
at command prompt tried mysql -u root - p admin
It says invalid crednitails.
pls advise some guidlines to start with mysql, like creating a new user and password and connecting to it and create tables
santomAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim RiddlesPrepress/OMS SpecialistCommented:
The command you entered is trying to connect to a machine named "admin". Is that your machine's name and will it resolve to that? Try entering the following command:

mysql -u root -p localhost

Enter your password at the prompt and see if that works.
0
Dan CraciunIT ConsultantCommented:
If you just installed it, it has no password, so simply use this:
mysql -u root

Here's the man page for creating a password for the root user: https://dev.mysql.com/doc/refman/5.6/en/default-privileges.html

HTH,
Dan
0
ldvhaiCommented:
You need to set up initially for MySQL (run only one time after installing MySQL) using the following command:
sudo /usr/bin/mysql_secure_installation
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

santomAuthor Commented:
I am using mysql in windows.

I tried this : mysql -u root -p localhost it as
        It asks for password i just unzipped i did not set any password. what password i have to use.?

I also tried : mysql -u root  -- this gives can not connect to mysql server.

Pls advise in detail to connect to MYsqll server.
0
Jim RiddlesPrepress/OMS SpecialistCommented:
How about trying this (logging in without a password):

mysql -u root localhost

Open in new window


If that doesn't work, then I am not sure what to do.  If you installed MySQL using the installer from Oracle's site, it should have prompted you during install to set a password for the root account.

Check out these instructions: MySQL 5.7 Post Installation Instructions
0
ldvhaiCommented:
You forgot setting password for your MySQL root account when the installer finishes.

If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
$ mysqladmin -u root password NEWPASSWORD

Open in new window


Reference: http://corlewsolutions.com/articles/article-21-how-to-install-mysql-server-5-6-on-windows-7-development-machine
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
santomAuthor Commented:
By following above link steps abel to setup tx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.