Thanks - but no luck with the grant: mysql> grant ALL on *.* to'root'@'10.1.2.

Thanks - but no luck with the grant: mysql> grant ALL on *.* to'root'@'10.1.2.

Post by Maurici » Sun, 27 Feb 2011 04:25:50


reetings,
My solution to your problem is:

1- Run MySQL Configuration Wizzard.
2- Choose to remove any previous configuration.
3- Restart your MySQL service.
4- Use XAMPP to access your MySQL Database with user "root" and passwrd "" (empty).

Consider getting a place online to host your MySQL database as I did.
First just for a proof of concept, but now I'm running a business site after some try/error issues.
Signup Now with Instant Activation -
<a href="http://www.000webhost.com/420083.html"> free MySQL online webhost</a>





































 
 
 

1. A grant to grant a role without granting the grant to the role

2. grant select with grant option to system

Hello,

this is a script I would like to be able to grab from the net no
matter where I am and run it as SYS.

Basically so far I always have to log on to the host machine as SYS in
case an user XZY happens to need to select from view e.g. V$INSTANCE,
am I am getting tired of that.


begin
for rec in (
select replace(table_name, 'V$', 'V_$') table_name
from dict
where table_name like 'V$%'
) loop
begin
execute immediate 'grant select on '
||rec.table_name||' to system with grant
option';
dbms_output.put_line(rec.table_name||' succeeded');
exception
when others then
dbms_output.put_line(
substr('table_name='||rec.table_name
||' '||sqlcode||' '||sqlerrm, 1, 255));
end;
end loop;
end;
/

3. Granting the ability to shadow without granting admin permissi

4. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f fails

5. Grant two table spaces to a user / Role grants

6. Grant Select without Grant Update

7. Granting the ability to shadow without granting admin permissions

8. subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=SYSTEM=f Fails

9. start up mysql skipping grant tables

10. granting more CPU has a process on solaris 10

11. Infogrames Granted D&D License For Next 10 Years

12. AAA air force 1s release dates, invisible air force 1s,air force 1s and jordans

13. Novell Finds Almost 10 Years' Worth of Errors in Past Stock Options Grants

14. 1's complement and 2's complement

15. UPDATE: Granting access to HKLM/Software/<application>