Homebrew Install Mysql and Connect to Workbentch

By - 
Install MySql in MacOS Seirra can be done as follows.
brew install mysql 
brew services start mysql
mysqladmin -u root password 'newpassword'
Login   ;      mysql -u root -p 
Get Config Location :mysql --help | grep cnf
Config Path :
 export MYSQL_PATH=/usr/local/Cellar/mysql/8.0.12
 PATH=$MYSQL_PATH/bin:$PATH
Connect Squrel
if you filed to collect  with mysql as follows :
 MySQL said: Authentication plugin 'caching_sha2_password' cannot be
  loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2):
  image not found
https://stackoverflow.com/questions/51179516/sequel-pro-and-mysql-connection-failed
Go to my.cnf file and in section [mysqld] add line:
default-authentication-plugin=mysql_native_password.
Then, login to mysql server from terminal and run mysql -u root -p, then inside shell execute this command: 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';
exit from mysql shell with exit and run sudo service mysqld restart.

Comments

Post a Comment

Popular posts from this blog

ENOENT: no such file or directory, rename : node_modules/async

By -
Image
I have gone trough follwing error ,when I was updating npm. npm ERR! path /Users/interlectivethree/firebase/fetchme/server/node_modules/winston/node_modules/async npm ERR! code ENOENT npm ERR! errno -2 npm ERR! syscall rename npm ERR! enoent ENOENT: no such file or directory, rename '/Users/interlectivethree/firebase/fetchme/server/node_modules/winston/node_modules/async' -> '/Users/interlectivethree/firebase/fetchme/server/node_modules/winston/node_modules/.async.DELETE' npm ERR! enoent This is related to npm not being able to find a file. npm ERR! enoent npm ERR! A complete log of this run can be found in: npm ERR!     /Users/interlectivethree/.npm/_logs/2017-07-07T14_17_29_016Z-debug.log I have done sevarel things like package wise unstall and install ,package relocating .But no success .But I think compleate unstall and reinstall is the best option and follwing commands used. npm uninstall ` ls - 1 node_modules | tr '/\n' ' ...
Read more

react-quill Integrate quill-image-resize-module

By -
Image
React-qill  is a great free package which can be used for design editors. However, if you are using the image upload feature, there is a problem of integrating resize package. This was discussed in may treads and I was able to find the best approach integrate it with react-starter-app. https://www.npmjs.com/package/quill-image-resize-module If you use the following code, import Quill from ' quill ' ; import { ImageResize } from ' quill-image-resize-module ' ; Quill . register ( ' modules/imageResize ' , ImageResize); const quill = new Quill (editor, { // ... modules : { // ... imageResize : { // See optional "config" below } } }); The following error is common. TypeError: Cannot read property 'imports' of undefined var d = window.Quill.imports.parchment In order to overcome the issue , you have to update the node_modules/react-scripts/config/webpack.config....
Read more