Hi Guys,
I nstalled mysql in Libreelec but cann't access through 192.168.1.xxx:8000 even by 3306
LibreELEC:~ # mysqld.start
MySQLd is already running
LibreELEC:~ # mysqltest
mysqltest: Could not open connection 'default': 1045 Access denied for user 'root' localhost (using password: NO)
not ok
LibreELEC:~ #
I can access inside mysql through : mysql -u root -p and the status is running
What shall I do please?
MySQL defaults to local access only. If you want to access the database from outside the server, you need to double-check the database user rights for your user.
Error 1045.. There is still a mismatch with stored and entered usernames and/or passwords.
Is the password correctly stored?
Perhaps mr vpeter can shed some light here.
What did you set as documentroot directory?
What did you set as documentroot directory?
How can I know what is my documentroot directory? and how can I set it?
First tell me which LE version you are using and which LAMP addon version. Then I can install it locally and check myself.
First tell me which LE version you are using and which LAMP addon version. Then I can install it locally and check myself.
LE 8.2.5 Generic x86-64
LAMP 8.2.104-Generic.x86_64
For me it works as it should. I can open web page https://forum.libreelec.tv/tests.php and open all tests (except mail which needs to be configured manually).
Maybe you interrupted install process and something didn't setup correctly.
Try stopping both services, remove addon data and start it again.
systemctl stop httpd
systemctl stop mysqld
rm -fr /storage/.kodi/userdata/addon_data/service.web.lamp
systemctl start mysqld
systemctl status mysqld
systemctl start httpd
systemctl status httpd
ps -ef | grep -E "mysql|httpd"How is the 'bind-address' configured by default?
