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

Heroku Django manage.py makemigrations - Error settings.DATABASES Please supply the ENGINE value

By -
Image
Hi ,While I'm dying hard for the make the migration done with heroku ,,, the following command  always lead to the above error . $ python manage.py makemigrations  "raise ImproperlyConfigured("settings.DATABASES is improperly configured. " django.core.exceptions.ImproperlyConfigured: settings.DATABASES is improperly co nfigured. Please supply the ENGINE value. Check settings documentation for more details" However it Takes me lot of time to understand  I'm using wrong command in heroku environment .Thanks for the below post ,Save a lot of time http://stackoverflow.com/questions/28138706/heroku-database-migration-does-not-create-tables Correct Command : $ heroku run python manage.py makemigrations panhidhaapp
Read more