cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Jacob Cadet
Cadet
  • 612 Views

Do280 mysql container user and password

lesson Do280:

Why when use the following command line can create any username and passwd in mysql container?

# oc new-app --name=mysqldb \

 --docker-image=workstation.lab.example.com:5000/rhscl/mysql-57-rhel7 \

 --insecure-registry \

 -e MYSQL_USER=ose \

-e MYSQL_PASSWORD=openshift \

 -e MYSQL_DATABASE=quotes

5 Replies
  • 564 Views

Re: Do280 mysql container user and password

@Jacob

Can you look into below, if any prob reply me

version: '3'services:
  database:  image: mysql:5.6  volumes:
    - dbdata:/var/lib/mysql
  environment:
    - "MYSQL_DATABASE=my_database_name"
    - "MYSQL_USER=my_database_user"
    - "MYSQL_PASSWORD=my_database_password"
    - "MYSQL_ROOT_PASSWORD=my_root_password"  ports:
    - "33061:3306"

 But I keep getting this error.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 Have you face same issue

Please Reply me ASAP

Thanks 

Nikhil John

oracle IT/DBM Admin

0 Kudos
Reply
Loading...
AshutoshBhakare Mission Specialist
Mission Specialist
  • 522 Views

Re: Do280 mysql container user and password

Its could be the issue of grant access, Please login to container and try to grant access to root 

0 Kudos
Reply
Loading...
gautham Cadet
Cadet
  • 35 Views

Re: Do280 mysql container user and password

CREATE USER username  WITH SYSID uid   | CREATEDB | NOCREATEDB 
| CREATEUSER | NOCREATEUSER  | IN GROUP groupname [, ...] | 
[ ENCRYPTED | UNENCRYPTED ]PASSWORD 'password' | VALID UNTIL 'time' 

 sql/pl sql 

0 Kudos
Reply
Loading...
Moderator
Moderator
  • 478 Views

Re: Do280 mysql container user and password

Hey, @Jacob@nikjohn1538,

Both of you are failing to specify some important information in your questions.

@Jacob, How exactly do you create the user accounts? What commands do you use and how do you verify the new users are able to log in?

@nikjohn1538, What is the output you are quoting in your question? How did you obtain that? Also, I see you are using the Docker hub MySQL image - do mind that image works differently from RHSCL MySQL images we mostly use in our courses.

Cheers,
Grega

A black cat crossing the street signifies that the animal is going somewhere.
[don't forget to kudo a helpful post or mark it as a solution!]
0 Kudos
Reply
Loading...
Flight Engineer Radesh Flight Engineer
Flight Engineer
  • 472 Views

Re: Do280 mysql container user and password

If I remember that template properly, I think if u do a --param=<variable>=<value> you will end up with a mysql container with the intended variables & values.

0 Kudos
Reply
Loading...
Join the discussion
You must log in to join this conversation.