Help - Search - Members - Calendar
Full Version: Easy Way To Assign Privileges While Out Of Order
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
CORAX
Large edit with HUGE thanks to CORAX for initial idea.

1) log into your site/database management.
2) Go to my page and fill in your details.

This does work.

swordz

CODE
...so if you want to assign these f**ed privileges anyway, do next:
1. Excuse me for my English =)
2. Go http://www.uuuq.com/user_db.jsp and save its source as 1.htm (for example)
3. Open 1.htm in Notepad or any editor you like
4. Find there a block:
<form action="" method="post">
<fieldset>
<legend>3. Assign Privileges</legend>
<div id="priv-user-db">
<label for="priv-user">Username:</label>
<select id="priv-user" name="user_name"></select>
<label for="priv-db">Database Name:</label>
<select id="priv-db" name="db_tbl"><option value="YOUR_BASE'.*">USER_YOUR_BASE.*</select>
5. Replace with:
<form action="http://www.uuuq.com/user_db.jsp" method="post">
<fieldset>
<legend>3. Assign Privileges</legend>
<div id="priv-user-db">
<label for="priv-user">Username:</label>
<select id="priv-user" name="user_name"><option value="USERNAME">USER_USERNAME</select>
<label for="priv-db">Database Name:</label>
<select id="priv-db" name="db_tbl"><option value="YOUR_BASE'.*">USER_YOUR_BASE.*
</select>

For example:

<form action="http://www.uuuq.com/user_db.jsp" method="post">
<fieldset>
<legend>3. Assign Privileges</legend>
<div id="priv-user-db">
<label for="priv-user">Username:</label>
<select id="priv-user" name="user_name"><option value="root">corax_root</select>
<label for="priv-db">Database Name:</label>
<select id="priv-db" name="db_tbl"><option value="main`.*">corax_main.*
</select>

6. Save, run, press "Assign Privileges"
7. Enjoy

(oh i forgot you must have original http://www.uuuq.com/user_db.jsp page opened and logged in to)
matome
Nice hack! Nothing can stop you laugh.gif Back to work then!
swordz
Normally I believe my job as moderator and hosting support would probably mean I should delete this, as it is basically injecting our server.

However, I do like the ingenuity and resourcefulness. So it's staying for now! Well done CORAX!

swordz
kostas_197
thanks CORAX, biggrin.gif
fer2674
thanks CORAX, good idea.
code
it's still error
John Whiteeeee
seems the solution has been blocked... doesn't work again
Cheers
norgematos
Ok people, here my solution. I have another database in zymic and I am using it temporaly, and wait for zymic solution.
CORAX
QUOTE(John Whiteeeee @ Jan 29 2009, 12:35 PM) *
seems the solution has been blocked... doesn't work again
Cheers

It still works. Just tested on newly created base.
Spektor
Still working for me!

Thanks for the classy workaround. I imagine it may also work for deleting users as well.
CORAX
QUOTE(Spektor @ Jan 29 2009, 01:12 PM) *
I imagine it may also work for deleting users as well.

Not tested yet, but no reason to fail.
Manish Agarwal
Excellent workaround !!!

Hats off to you!!
nossa
Hello

I did everything right as you said, when more come in phpmyadmin it says that "No Privileges" I do not know if I'm doing wrong because I am new to this area mysql and phpmyadmin ... because prior to the problem in the system I created a zymic database before making table and that I understand.

If you can help me how to create the table I will be grateful.

And sorry for my English ;D
cyberbuff
Doesn't work

P.S. Works! I made some mistakes at the first attempt. Thanks CORAX. Also we can do it with Firebug's Live Editing Features.
Cowslanlr
QUOTE(cyberbuff @ Jan 30 2009, 03:12 AM) *
Doesn't work


Not working.
max200
hi

thanx man its working

I have a data base now

but still cant connect to it cause the user password isn't working

any way thanx for helping

still have to wait .... sad.gif
gatex
MAN BIG THANKS ITS WORKING FOR ME!!!
Brandon
Nice one, CORAX.

Will be helpful.
LS2
how create db username & password
i have db created but i cant create username + pass
help unsure.gif
sucker
QUOTE(LS2 @ Jan 30 2009, 04:57 PM) *
how create db username & password
i have db created but i cant create username + pass
help unsure.gif


same here: I managed to create a database, but when trying to create a database username I do get a "successful" message, but the username option is always blank! dry.gif


QUOTE(matome @ Jan 28 2009, 08:09 PM) *
Nice hack! Nothing can stop you laugh.gif Back to work then!


haha, so you actually have to 'hack' the system to manage to fix the privileges... must be one of the worst web hosting services out there sad.gif is there a way to cancel your account?
Brandon
QUOTE(sucker @ Jan 30 2009, 07:07 PM) *
haha, so you actually have to 'hack' the system to manage to fix the privileges... must be one of the worst web hosting services out there sad.gif is there a way to cancel your account?


You have done my head in.

I belive Zymic is one of the best free hosting services on the web! I'm sure many members will agree, the ZCP has recently broken because the LP creators has fucked it up.

And no you can't delete your account, try to search the forum you will find that many members has asked but always get told the same awnser wink.gif
sucker
QUOTE(Crown @ Jan 30 2009, 07:14 PM) *
You have done my head in.

I belive Zymic is one of the best free hosting services on the web! I'm sure many members will agree, the ZCP has recently broken because the LP creators has fucked it up.

And no you can't delete your account, try to search the forum you will find that many members has asked but always get told the same awnser wink.gif


I 'believe', but don't 'experience' and that's the only thing that counts. I'm glad I didn't decide to go for the 'Premium Hosting' without trying it first, or at least 'trying' to try. dry.gif
Brandon
QUOTE(sucker @ Jan 30 2009, 07:34 PM) *
I 'believe', but don't 'experience' and that's the only thing that counts. I'm glad I didn't decide to go for the 'Premium Hosting' without trying it first, or at least 'trying' to try. dry.gif

Premium hosting has nothing todo with Zymic servers, it lunarpages servers just a refferal thing i guess.
sucker
OK, anyway; how can I fix this, or is it perhaps the same to just give up at the same time and admit that Zymic (probably) has successfully managed to trick me tongue.gif
CORAX
Large edit with HUGE thanks to CORAX for initial idea.

1) log into your site/database management.
2) Go to my page and fill in your details.

This does work.

swordz

CODE
Oh men. I dont understand what problems do you all have... To work with your databases you should:

1. Create databases, usernames, passwords etc FROM ORIGINAL PAGE!

2. Set privileges FROM HACKED PAGE while ORIGINAL PAGE IS OPENED in another window.

3. If you need, delete users from just one more page, hacked by the same way:

<form action="http://www.uuuq.com/user_db.jsp" method="post" onsubmit="return confirm('Are you sure you want to delete the selected user?')">
<fieldset>
<legend>Delete a database user</legend>
<label for="mysql-delete-user">User Account:</label>
<select id="mysql-delete-user" name="user_name"><option value="root">corax_root</select><button type="submit" class="button-delete"><span>Delete</span></button><input type="hidden" name="mode" value="delete_user">
</fieldset>
</form>

(of course, replace corax and root with your account and your user)

4. In any case, after all the steps USERNAMES still WONT BE LISTED on ORIGINAL PAGE!!! You have to remember them!
swordz
I have spent a while automating this for you. New instructions:

1) Log into your site.
2) Visit my page and fill in the details.

swordz
kaetta
=____=
It doesn't work. I tried by two way :
1. Use the user and database weren't exist that before.
2. Use the user and database have been exist before.
And, they all didn't work out.
=____=
Poor for me ! =.=
sucker
Failed, Again! dry.gif
swordz
You have to have already created the database and user. My page only assigns privileges- no more.

And it does work, at least for my site, and I created a new database and user to test it on.

swordz
sucker
OK I see, but when I try to create a database-user I get a 'successful' message, but when I then try to select the user to assign the privileges (so I can login to phpMyAdmin), no users are selectable and the option gives me just a blank dropdown:

CODE
<legend>3. Assign Privileges</legend>
<div id="priv-user-db">
<label for="priv-user">Username:</label>
<select id="priv-user" name="user_name"><option value="USERNAME" selected>{it's just blank}
</select>
<label for="priv-db">Database Name:</label>
<select id="priv-db" name="db_tbl"><option value="YOUR_BASE'.*">{this is OK}.*

When I hovever create a user with the same name I get that 'the user already exists'! sad.gif
swordz
The main zymic mysql page is broken. Use my page instead.

swordz
sucker
QUOTE(swordz @ Jan 31 2009, 04:42 PM) *
The main zymic mysql page is broken. Use my page instead.

swordz


like I said before; I already have used your and CORAX's database script with numberless database- name and user combinations, but with the same outcome every f***ing time:

CODE
There are currently no privileges granted
dry.gif
kaetta
QUOTE
You have to have already created the database and user. My page only assigns privileges- no more.

And it does work, at least for my site, and I created a new database and user to test it on.

swordz


Look like you have not read my post carefully, or my English is too bad... =='' I said that I tried two way :

1. Use the user and database weren't exist that before.

2. Use the user and database have been exist before. (that means I have already created the database and user, but it still doesn't work out ! =.=)

Whatever, look like I have to practice my English more... It's too bad. =.=

P/S 1 : Can you tell me how long is it to fix this problem ? ' '

P/S 2 : You use FireFox or Internet Explore ? ' '
RCVGW
I am having the same problem i used the page that swordz provided and it seems to work but when i log in to PHPMyAdmin i am told that the account has not granted privileges. How can i fix this?
CORAX
Seems like swordz' page doesnt work (tried to use it myself tonight) - it just redirects to .jsp page without 'successful' message, phpmyadmin still doesnt see any privileges after that happy.gif
And greetings to all 'sorry-for-my-english' Russians here )
swordz
Oops. I missed out a `. It now works.

Sorry,

swordz
CORAX
He-he)
Swordz, any help on http://www.zymic.com/forum/index.php?showtopic=15916 problem? I think it's all about 'safe mode' but not sure. Any way to fix or maybe another way to install addons in Joomla?
LS2
QUOTE(swordz @ Jan 31 2009, 04:42 PM) *
The main zymic mysql page is broken. Use my page instead.

swordz

10x
man it's working rolleyes.gif
swordz
QUOTE(LS2 @ Feb 1 2009, 11:49 AM) *
10x
man it's working rolleyes.gif

Phew... Glad to hear it!

swordz
zerosones
THIS LINK WORKED PERFECTLY!

mucho thanks

QUOTE(CORAX @ Jan 31 2009, 08:21 AM) *
Large edit with HUGE thanks to CORAX for initial idea.

1) log into your site/database management.
2) Go to my page and fill in your details.

This does work.

swordz

CODE
Oh men. I dont understand what problems do you all have... To work with your databases you should:

1. Create databases, usernames, passwords etc FROM ORIGINAL PAGE!

2. Set privileges FROM HACKED PAGE while ORIGINAL PAGE IS OPENED in another window.

3. If you need, delete users from just one more page, hacked by the same way:

<form action="http://www.uuuq.com/user_db.jsp" method="post" onsubmit="return confirm('Are you sure you want to delete the selected user?')">
<fieldset>
<legend>Delete a database user</legend>
<label for="mysql-delete-user">User Account:</label>
<select id="mysql-delete-user" name="user_name"><option value="root">corax_root</select><button type="submit" class="button-delete"><span>Delete</span></button><input type="hidden" name="mode" value="delete_user">
</fieldset>
</form>

(of course, replace corax and root with your account and your user)

4. In any case, after all the steps USERNAMES still WONT BE LISTED on ORIGINAL PAGE!!! You have to remember them!

davidnez
I read all of topics of this thread but it still not run.

I prove that the database is allready created, the user also too.
In the screen says that de permission are assigned.

But when I entry to create de tables in the database, the database is not selected and I can't see how to do.

The registration is:

<legend>3. Assign Privileges</legend>
<div id="priv-user-db">
<label for="priv-user">Username:</label>
<select id="priv-user" name="user_name"><option value="davidnez">root_davidnez</option></select>
<label for="priv-db">Database Name:</label>
<select id="priv-db" name="db_tbl"><option value="main`.*">davidnez_main.*</option></select>
</div>

So the database must be main, the user of database davidnez_main and the user of the account davidnez. I can entry the phpadmin with davidnez_main user but I don't see the database.

Can anyone help me? Thanks, davidnez.
davidnez
The process active when I entry in phpAdmin:
CORAX
QUOTE(davidnez @ Feb 2 2009, 02:53 PM) *
<select id="priv-user" name="user_name"><option value="davidnez">root_davidnez</option></select>

Not 'root_davidnez', must be 'davidnez_davidnez'
Andrew-C
QUOTE(sucker @ Jan 30 2009, 02:07 PM) *
haha, so you actually have to 'hack' the system to manage to fix the privileges... must be one of the worst web hosting services out there sad.gif is there a way to cancel your account?


Zymic is currently experiencing issues with its Hosting Panel Provider, Zymic is not at fault as the hosting panel provider was the one to mess everything up, this will be fixed soon

and no you can not cancel your account, It is not an option with our current hosting setup
mysticskate
It doesn't work for me... I can't access PHPmyADMIN but my username is in the privilege's list ???
ZillaIIDope
Thanks a million for this

Is there a way to delete excess users?
swordz
When we're no longer null routed...

Visit this page. You need to know the database/user names, and you need to be logged into the control panel.

swordz
Daniel Moscarella
it works! thanks! laugh.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.