Installed Percona Server / Mysql 5.7 and cannot start without root password.

To fix this:


  1. Make sure your data dir is empty. 
  2. mysqld --initialize-insecure  --datadir=/path-to-datadir --user=youruser
  3. Done. Now you have root user with no password

Comments

Post a Comment

Popular posts from this blog

PIP - upgrade all packages from requirements.txt (interactively)

Image
pip-upgrader An interactive pypi pip requirements upgrader. Because upgrading requirements, package by package, is a pain in the ass. It also updates the version in your requirements.txt file. Purpose This cli tools helps you interactively(or not) upgrade packages from requirements file, and also update the pinned version from requirements file(s). If no requirements are given, the command attempts to detect the requirements file(s) in the current directory. Quick preview: Installationpip install pip-upgrader Usage
Read more

Improve font rendering for IntelliJ IDEA / Pycharm in Ubuntu

Image
Stock font rendering in Pycharm / Intelliji IDEA is horrible on Ubuntu. To improve it, change the following:



First of all, we need to install Infinality fonts:
sudo add-apt-repository ppa:no1wantdthisname/ppa
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install fontconfig-infinality

sudo /etc/fonts/infinality/infctl.sh setstyle linux
sudo gedit /etc/profile.d/infinality-settings.sh
# and set
USE_STYLE="UBUNTU"
Installed the patched OpenJDK with fontfix:
sudo apt-add-repository -y ppa:no1wantdthisname/openjdk-fontfix
sudo apt-get update
sudo apt-get install openjdk-7-jdk
In $IDEA_HOME/bin/*.vmoptions  add the following: (PS: $IDEA_HOME is the path to IntelliJIdea or Pycharm)
-Dawt.useSystemAAFontSettings=lcd
-Dswing.aatext=true
-Dsun.java2d.xrender=true
and in ~/.profile  add
export PYCHARM_JDK=/usr/lib/jvm/java-1.7.0-openjdk-amd64"


or whatever the installed java path is.

Reboot.

Start the IDE and enjoy perfect fonts.

Read more