pro   5698

« earlier    

Huawei Mate 20 (S$998), Mate 20 Pro (S$1,348) Comes to Singapore 27 October
Launched in London yesterday, the Huawei Mate 20 series is the brand’s most ambitious yet. It brings over the triple camera set-up found on its previous P20 line of smartphones but fits them in a package that is smarter and more powerful than ever. These phones will be available in Singapore on October 27, starting...

The post Huawei Mate 20 (S$998), Mate 20 Pro (S$1,348) Comes to Singapore 27 October appeared first on .
Huawei  Mate  20  (S$998)  Pro  (S$1  348)  Comes  to  Singapore  27  October 
yesterday by vrzone
Script to open a mysql database in Sequel Pro from a service in docker-compose.
A gist of an Bash Shell Script to open up Sequel Pro MacOS / MacOS X app with credentials to view a MySQL database running within a Docker container.
github  gist  script  bash  shell  open  sequel  pro  sequelpro  database  mysql  docker  container  credentials  totry  guide  reference 
7 days ago by racl101
Connecting to a mysql running on a Docker container · Issue #95 · docker-library/mysql
Frankly, this forum page has no consensus on a solution to this issue. Nevertheless, what worked for me on my set up with running MacOS as the Docker host and running a container with: Ubuntu 16.04 and MySQL 5.7 is the following:

1) Within the container: change in /etc/mysql/mysql.conf.d/mysqld.cnf the bind-address option from 127.0.0.1 to 0.0.0.0
2) Restart MySQL server (note that whenever you start MySQL you must use this command in the Dockerfile:

RUN sed -i -e"s/^bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/" /etc/mysql/mysql.conf.d/mysqld.cnf
RUN find /var/lib/mysql -type f -exec touch {} \; && service mysql start

That is, you must touch the files in /var/lib/mysql and then start the server with service command and not systemctl.

Next, create a user separate from root e.g. dev_1, in MySQL and given them privileges to their '0.0.0.0' and '%' hosts. Like this in the Dockerfile:

RUN find /var/lib/mysql -type f -exec touch {} \; && service mysql start && mysql -uroot -proot mysql -e "GRANT ALL ON *.* TO root@'0.0.0.0' IDENTIFIED BY 'secret' WITH GRANT OPTION; CREATE USER 'dev_1'@'0.0.0.0' IDENTIFIED BY 'secret'; GRANT ALL ON *.* TO 'dev_1'@'0.0.0.0' IDENTIFIED BY 'secret' WITH GRANT OPTION; GRANT ALL ON *.* TO 'dev_1'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; FLUSH PRIVILEGES;"

Then when you start the container you must publish the port number like so:

docker run -t -d -p 4406:3306 ubuntu_16_04_lemp_php_7_2:latest

If your container stops prematurely, then you might want to add a CMD line in your docker file to run a start.sh script and within that script you might want to add something like this:

# stupid hack to keep container from being stopped
tail -f /dev/null

Finally, to connect to your DB instance on your local MacOS machine with an app like Sequel Pro for example, use the following credentials:

Host: 0.0.0.0
Username: dev_1
Password: <dev_1_password>
Port: 4406

If you don't like to use port 4406, try 3307, 3308, 3309.
github  forum  howto  example  troubleshoot  mysql  server  docker  host  connection  issue  sequel  pro  mariadb  client  hostname  docker-machine  ip  address  ipaddress  guide  reference  toread  tolearn  totry  tounderstand  image  port  detached  database  credentials 
7 days ago by racl101

« earlier    

related tags

'call  (2018)  (or  (s$1  (s$699)  (s$998)  (s$999)  -  1  11  12.9  14  14:  17-10  18  18:9  1st  2  20  2019  26  27  3  348)  4  40  4runner  5.7-inch  5  6  600  660  6gb  8  8710  980  [2017  a  a22  a45  a9  about  abtreibung  acceleration  activating  address  after  ai  all  amazon  ambidextrous  an  and  aperture  apple  apple’s  apply  ar-15  architecture  archive  are  art  article  as  asus  at  austin  aws  bash  better?  black  blog  blue  bluetooth  bolt  bonuses]  boost  bowl-lift  breaks  broomsticks  c#  camera  cameras  cartridge  cash  cashless  censor  certification  cheap  chinese  client  code  college  colour  come  comes  coming  compact  comparison  complete  con  connacht  connection  container  contra  core  create  credentials  das  dashboard  data  database  delamination  demo  demokratie  deploy  design  detached  details  device  digital-health  direkte  display  diversifies  dji  docker-machine  docker  does  doesn’t  drone  dual  duty'  dvr  dzone  earbuds  earphones  edinburgh  edit  egpu  elasticache  eluga  emerge  enry  everymac  example  excited  experience  external  f9  face  familia  far  faze  fde  feature  features  file  final  fingerprint  firmware  first  focus  football  for  form  forum  four  framework  framwork  free  front  für  galaxy  gamer  games  gaming  garcía  get  getting  gf63  gist  github  gnip  go  goals  gpu  grip  guide  hands-on  happy  happystudents  hardshell  having  hdhomerun  headmouse  health  healthcare  heap  heart  here’s  his  history  hohmann  host  hostname  how  howto  hp  huawei  hyper  ida  ifttt  image  improvements  in-display  in  incase  india  ink  insert  install  ip  ipad  ipaddress  is  isaiah  issue  issues  it?)  it  itel  java  javascript  job  jquery  july  kichenaid  kids'  kirin  know  kontra  laptop  lark  launched  launches  leaked  leben  lenovo  license  like?  like  line  live  look  lukas  lvad  m1  mac  macbook  macos  macosx  mariadb  match  mate  mathematics  mavic  max  mbp  meizu  memcache  memory  mi  microsoft  migration  mil-spec  mixer  mobile  models  moi  money  monitor  more  msi  mysql  myst  métier  need  new  no-wear  nodexl  nokia  notch  note  notebook  nvidia  october  of  officejet  on  online  open  oppo  orientation  other  oto  overseas  package  panasonic  perf  phone  pinterest  pistol  playing  plex  plugin  port  ports  post  powershell  price  printer  ps42  quart  quick  quidditch  r17  ready:  really  realme  rear  receive  recover  recovery  redis  redmi  reference  releases  replacing  review  review]  rivalry  s5  samsung  scanner  scores  screen  script  sep  sequel  sequelpro  series  server  setup  shell  shield  silent  silicone  singapore  single  sleep  smartnav  snapdragon  so  soc  soccer  social-network  some  speaks  specifications  specs  sports  spotted  stand  star  starter  stock  studio  surface  tage  teased-  technology  the  this  thunderbolt  titter  to  tolearn  tools  top  toread  totry  tounderstand  toyota  trd  triple  troubleshoot  true  tus  tutorial  tv  two  université  unlock  up  update  updates  usain  usb-c  user  users  utg  v11  v8  v9  variable  variant  vivo  vmware  volksabstimmung  vs.  vs  we  web  webcomponents  what  which  will  wireless  with  wordpress  workbench  wpmudev  wrestling  x  x1  x5  xiaomi  y83  ya  yanet  you  zenfone  zoom  ¡adquiere  étranger    🚀[best 

Copy this bookmark:



description:


tags: