root@lxdMosaic:~# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 8.0.25-0ubuntu0.20.04.1 (Ubuntu)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> use LXD_Manager;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select User_ID, User_Name from Users;
±--------±----------+
| User_ID | User_Name |
±--------±----------+
| 1 | admin |
±--------±----------+
1 row in set (0.00 sec)
mysql> update user set User_Password = “$2y$10$gDLdVHx2DEuoB81DobEcn…FIGScRjFg6hoN/kDmvJfn6SmMP0OW2” where User_ID = 1;
ERROR 1146 (42S02): Table ‘LXD_Manager.user’ doesn’t exist
mysql> update User set User_Password = “$2y$10$gDLdVHx2DEuoB81DobEcn…FIGScRjFg6hoN/kDmvJfn6SmMP0OW2” where User_ID = 1;
ERROR 1146 (42S02): Table ‘LXD_Manager.User’ doesn’t exist
mysql>
After login I am going to add server then given admin with password. but when I have click on
Launch LXD mosaic it shows “Cant run first run /var/www/LxdMosaic/src/classes/Tools/InstanceSettings/FirstRun.php 31”
Set the admin password to NULL and you will be able to run first run again.
Because you have no servers it wants you to run first run, the admin password should not be set when first run is run - this prevents people abusing “first run”. If you have deleted all the hosts you need to set the admin password back to NULL.
mysql> use LXD_Manager;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update Users set User_Password = NULL where User_ID = 1;
ERROR 1048 (23000): Column ‘User_Password’ cannot be null