Solved

Issues creating and logging in as a new user

Posted on 2012-04-06
3
221 Views
Last Modified: 2012-08-13
Ive been having issues logging on as a new user, and Im not sure what Im doing wrong.

Im creating the usesr as:-
D:\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 59
Server version: 5.5.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

Open in new window


Which all seems fine, so then I try and connect:-
D:\mysql\bin>mysql -h localhost -u myuser -pmypass
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES)

Open in new window


Any ideas what Im doing wrong
0
Comment
Question by:tonelm54
  • 2
3 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37816469
did you grant permission to user?
0
 

Author Comment

by:tonelm54
ID: 37816533
Yes, but still same issue:-

D:\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 74
Server version: 5.5.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

D:\mysql\bin>mysql -h localhost -u myuser -pmypass
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES)

Open in new window


Any other ideas?
0
 
LVL 17

Accepted Solution

by:
Anuroopsundd earned 500 total points
ID: 37816579
flush priviledges and then restart MYSQL... then try to login back.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Format data and display in formatted manner 3 55
duplicate data not insert in mysql 46 51
Mysql not caching queries 4 63
Selecting specific rows 3 50
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now