MYSQL – Page 2 – My Tech Blog

Command Line Connection with MYSQL

June 4, 2018August 23, 2017 by mark

If you are wanting to connect to a remote database using the command line with MySQL, you first need to download the MYSQL client available here Open a DOS shell and run the following: mysqlsh /sql -u aurora -p mypassword -h auroratest-1.cluster-xxxx.ap-southeast-2.rds.amazonaws.com AURORATEST Then run your query mysql-sql> select count(*) from AURORA.PERSON_AWS; +———-+ | count(*) … Read more

Protected: How to calculate radius with MySQL

June 4, 2018August 22, 2017 by mark

There is no excerpt because this is a protected post.

How to change a MYSQL User Password

August 16, 2017 by mark

Solution Step 1. Login to the relevant server as any user and login to mysql as described below cd /usr/local/mysql/bin ./mysql -uroot Change the user password update mysql.user set password=’indreport’ where user=’indreport’; Query OK, 0 rows affected (0.11 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql> commit; Query OK, 0 rows affected (0.00 sec)