The Droid TV thread

d4zza said:
10 times. Makes no difference.
Click to expand...

Reset the MXQ to factory settings, or to stock. Then try again, as there might be issues with a custom firmware which i doubt, but its worth a try.

PS i should follow my own advice, but i aint going to lose all the things that have already been loaded as i have no clue how to reflash or to get the things back again. Besides, i cant even get into the settings to factory reset
 
AVSupply said:
Does your root user have a password set?
Click to expand...

Yup I set it up in the MySQL setup. Password works to login. Create user, cool. I even created a table to test, works.
Assign privileges. Nope.

Icemanbrfc said:
Reset the MXQ to factory settings, or to stock. Then try again, as there might be issues with a custom firmware which i doubt, but its worth a try.
Click to expand...

It's got nothing to do with the MXQ, it's the MySQL DB on the PC.
 
d4zza said:
Yup I set it up in the MySQL setup. Password works to login. Create user, cool. I even created a table to test, works.
Assign privileges. Nope.



It's got nothing to do with the MXQ, it's the MySQL DB on the PC.
Click to expand...

im not familiar then with MySQL but are you using a local host of some sorts? Maybe try and point directly to the mySQL database. Also do you have both read and write privileges set and that you have the correct permissions for whatever scripts you require?
 
try and change your password, then check via control panel and any of your folders and files are hidden if they are hidden, then unhide them. If its not hidden, go the program data folder, and search for mySQL folder and delete it. Uninstall mySQL, and reinstall it, then it should ask for your new password, and see if it works.
 
There is a file for the config of mySQL that you need to change to allow access from devices on a network. Even if you have a password you need to get the config correct. I will try to find my notes on it and post later.
 
Run your last command using sudo after stopping the mysql service
Code:
sudo service mysql stop
sudo mysqld --skip-grant-tables
The latter wiil, in my experience, not return to a command prompt

In another terminal, start the mysql client and select the mysql database. If the root user entries are still there, just set a password using update user set password=password('yourpassword') where user='root'.

If there are no root entries, use grant all privileges on *.* to 'root'@'localhost' identified by 'yourpassword' with grant option.

Next exit the client, find the pid of the running mysql daemon and kill it.

Start the mysql daemon using sudo service mysql start and try again to get in.

PS you can ignore warnings about lower-test and higher-test.

Have your mysql daemon running the normal way. Start your mysql client as shown below
Code:
mysql -u debian-sys-maint -p
In another terminal, 'cat' the file /etc/mysql/debian.cnf. That file contains a password; paste that password when prompted for it.

The debian-sys-maint user has full privileges so you should be able to run the earlier mentioned grant statement. Don't forget to flush the privileges before quiting the client.
 
Icemanbrfc said:
try and change your password, then check via control panel and any of your folders and files are hidden if they are hidden, then unhide them. If its not hidden, go the program data folder, and search for mySQL folder and delete it. Uninstall mySQL, and reinstall it, then it should ask for your new password, and see if it works.
Click to expand...

Have done all the numerous times. End result is still the same.
I even used Revo uninstaller which kills all traces down to reg level. Fresh clean install, same result.

It def looks like a permissions issue somewhere, I need someone to point me in the right direction, as the XBMC tutorial doesn't cover it and Googling that error brings loads of issues up and I can't find ones relevant to Windows.
 
d4zza said:
Yup I set it up in the MySQL setup. Password works to login. Create user, cool. I even created a table to test, works.
Assign privileges. Nope.



It's got nothing to do with the MXQ, it's the MySQL DB on the PC.
Click to expand...


Can you try run the following commands

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

FLUSH PRIVILEGES;

GRANT ALL ON *.* TO 'root'@'localhost';
 
d4zza said:
Have done all the numerous times. End result is still the same.
I even used Revo uninstaller which kills all traces down to reg level. Fresh clean install, same result.

It def looks like a permissions issue somewhere, I need someone to point me in the right direction, as the XBMC tutorial doesn't cover it and Googling that error brings loads of issues up and I can't find ones relevant to Windows.
Click to expand...

out of interest sake, is this the only way to share your XBMC library?
 
The file is my.cnf and it gets updated by the grant commands in the previous posts. Be careful with the quotes in your statement. The file can be edited and then mySQL restarted to read the updated file. The file will be in a folder defined by your install. This link might help http://kb.parallels.com/en/1134
 
You know, screw this ****. I'm going to install WAMP and work everything through MySQL there and PHPMyAdmin. Over this.

Will let you know :D

*UPDATE*

Doing it through PHHPMyAdmin was a dream! Worked right off the bat! No issues, no hangups, NOTHING!

The DB is now populated, now when I get home later I will put the xml file onto my DroidTV and should all work hunky dory!
 
Last edited:
whooo hooo power supply sorted, well i need to go and pick it up. fingers crossed that will do the trick :D
 
heartbroken said:
I hope you can get it sorted - I haven't turned on mine since the weekend. I think I am going to rather just get a Roku 3 next week.
Click to expand...
What is your issue again? I must say I'm happy with it, at least with the brief time it was working. Why do you want to leave it?
 
Icemanbrfc said:
What is your issue again? I must say I'm happy with it, at least with the brief time it was working. Why do you want to leave it?
Click to expand...

Netflix, I got it for my parents to watch Netflix on, but it refuses to work over wifi and even on the lan it's not all that stable. The rest is rather cool I suppose, will keep it for myself, but it will never work for them.
 
heartbroken said:
Netflix, I got it for my parents to watch Netflix on, but it refuses to work over wifi and even on the lan it's not all that stable. The rest is rather cool I suppose, will keep it for myself, but it will never work for them.
Click to expand...
Something must be wrong somewhere. I don't recall any of the other guys having issues with Netflix. Strange one
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X