Phpmyadmin root login not possible

Hi there theres one thing i did not do which i will try tonight. I think after watching a you tube video i need to add an advanced setting xml on the server. As from a video i saw php admin will then show videos as a database item. If this does not work after that i will submit the steps i have taken encase something is missing.

Well not especially on the server but on every client (and your server in your case is also a client). You can use MyOSMC to configure the MySQL settings which then will be added to the advancedsettings.xml.

Write lets start from scratch. After i have followedd this guide and as i want to use the ras berry pi as a server client what is next as still not able to see movie database inside mysql

I’ve improved on them further by finding instructions on adding Apache, Python and phpmyadmin to administer the MySQL.

Install OSMC, add SSH & FTP servers

Make sure OSMC web server is not set to Port 80, change to 8080

sudo apt-get update
sudo apt-get dist-upgrade

sudo apt-get install apache2 -y (then browse to the Pi’s IP address to confirm)

sudo apt-get install php7.0 libapache2-mod-php7.0 -y
sudo apt-get install mysql-server php7.0-mysql -y

If not asked for a password for Mysql -
sudo mysql_secure_installation
Enter root password as ‘root’

sudo service apache2 restart

sudo mysql
create user ‘kodi’ identified by ‘kodi’; (this is the username I’ve historically used)
grant all on . to ‘kodi’;
flush privileges;
quit

sudo apt-get install python-mysqldb
sudo apt-get install phpmyadmin
select Apache 2 server, then say Yes to configure database with dbconfig-common
Enter root password

sudo nano /etc/apache2/apache2.conf
at the bottom add this line
Include /etc/phpmyadmin/apache.conf
Exit by Ctrl-X
sudo /etc/init.d/apache2 restart

Then check phpmyadmin is working by going to 192.168.1.xxx/phpmyadmin
login with kodi/kodi

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
locate the line
bind-address = 127.0.0.1
and change the IP
bind-address = 0.0.0.0
Ctrl+X to exit, confirm you want to save the file

Restart the service
sudo service mysql restart

Did you configured Kodi to use the Database? Either via MyOSMC -> Network -> Mysql or by adding the information to advancedsettings.xml? And did you then imported your backup?
https://kodi.wiki/view/MySQL/Setting_up_Kodi

You need to forget about Apache, Python,phpmyadmin for now.

Until you can make MySQL/mariadb and advancedsettings.xml work then none of that other crap matters…

3 Likes

Hi there going to reformat my memory card and start from scratch again. Willnlet you know how i get on.

Just a couple of things. What is better lamp stack or xammp as i have been using lamp.

Is it better to assign 0.0.0.0 as the binding address or the lan address of the pi.

Please stop posting to the MySQL wiki thread when your query is clearly off topic!

Moderation: Post moved

Why are you even installing phpMyAdmin? Unless you are planning on manually making changes to the database then there is no need for it. 99% of users just install mysql and forget it.

Thanks, yeah im goiing to retry and start from scratch , just our of curisoerty which is better xammp or lamp stack.

You are asking for an objective answer to a question that really can only have a subjective answer. The subject matter is also quite out of scope for this forum as well. You should be seeking general debian/linux support on more suitable forums if you want suitable answers.

I’m going to ask again: WHY do you need phpMyAdmin???

Just because i want to and so i can view the data nothing more than that.

now trying to log in on php my admin

CREATE USER ‘osmc’@’%’ IDENTIFIED BY ‘osmc’; not letting me in

We’re not going to give any assistance with phpmyadmin. If you need assistance with configuring your Kodi installation to point to MySQL, we’ll be happy to help.

Additionally, if you continue to clutter the MySQL wiki thread with off topic posts after having been asked not to do so twice previously and now a third time, your account will be suspended from making any posts for 3 days.

3 Likes

Hi

I have got mysql working next step is connecting my 2nd device to the server. I have copied over the sources and advanced settings xml to kodi on my tablet. When i open kodi up on the tablet i see all my movies but they wont play. It says movie no longer in libary do you want to remove. Is there my server is running samber and is on 192.168.1.118

Well I am actually not sure if we should continue this topic in this thread (which is totally not related to Kodi client connectivity to MYSQL) but let’s move on to get you out of our mind fast.
Provide full logs from your Vero so that we can review what might be wrong.

To get a better understanding of the problem you are experiencing we need more information from you. The best way to get this information is for you to upload logs that demonstrate your problem. You can learn more about how to submit a useful support request here.

Depending on the used skin you have to set the settings-level to standard or higher, in summary:

  • enable debug logging at settings->system->logging

  • reboot the OSMC device twice(!)

  • reproduce the issue

  • upload the log set either using the Log Uploader method within the My OSMC menu in the GUI or the ssh method invoking command grab-logs -A

  • publish the provided URL from the log set upload, here

Thanks for your understanding. We hope that we can help you get up and running again shortly.

OSMC skin screenshot:

You did a single file import of your library didn’t you? This would mean that all your media has its original file paths. Your original file paths were to a local disk at /media/Elements/... weren’t they? If so that is not a path that your tablet can access them at. You have to either change your sources so they are able to be accessed from the same file path on all machines (such as smb://ip/folder) or you have to put a path substitution in your advancedsettings.xml file that fixes the file path.

Hi there i read somewhere that the exporting of the libary was an option did not need to do that step unless you were migating your libary. Anyhow do you have an example advanced settings showing the substitute path. Pls

https://kodi.wiki/view/Path_substitution

You are migating (sic) your libary (sic) from a local path to something that can be accessed over a network.

Yes. There is a search function on this site and if you use it you will find that I have already shown two other people exactly how to do this in this last week.

1 Like