I don’t know how many times I have forgotten passwords, you would think I would learn to keep them safe somewhere. Well, if you are forgetful like me, here is how to reset the root password of mysql. #/etc/init.d/mysql stop #mysqld_safe –skip-grant-tables & #mysql -u root mysql> use mysql; mysql> update user set password=PASSWORD(“newpass”) where …
Category: Database
Permanent link to this article: https://daherlabs.mywire.org/wordpress/?p=7
Nov 12 2013
FreeNAS Add ISCSI Extents
I use this script to quicly add an ISCSI target cloned from a snapshot. This still needs a lot of work, but the intent is to have an automated process create ISCSI targets for diskless station to boot from. The script takes 2 args: #./addiscsi identifier what-to-clone #./addiscsi newname iscsi-win7x86 #!/bin/bash if [ -z $1 …
Permanent link to this article: https://daherlabs.mywire.org/wordpress/?p=18
Nov 12 2013
Create MySQL DB
The following is a quick example on how to create a database in mysql. You would type secctions in blue. #mysql -u root -p Enter password: Create a DB called blogger1 mysql> create database blogger1; Allow user ‘xyz’ with password ‘xyzpassword’ access to server mysql> grant usage on *.* to xyz@localhost identified by ‘xyzpassword’; Allow …
Permanent link to this article: https://daherlabs.mywire.org/wordpress/?p=13