Re: Mysql

On Mon, 31 Mar 2008, Blattus Slafaly 0/00 ? ? ? wrote:-

It won't accept my hostname. I get up to mysqladmin version, works ok.

Then mysqlshow fails. Mysqladmin -u root password new_password works,

mysqladmin -u root -h my_system_hostname password mysql_root_password
fails, cannot access with that hostname.

I found that part of that problem was caused by having the host name
entered into /etc/hosts. In my case I removed the entry:

127.0.0.2 lion.davjam.org lion

then logged in using:

mysql -h localhost -u root -p

After that, I entered these two commands:

grant all privileges on *.* to 'root'@'lion.davjam.org' identified by '<my password>';
grant grant option on *.* to 'root'@'lion.davjam.org' identified by '<my password>';

The first command, despite saying all privileges, doesn't give the
ability to grant users access rights. Using the second command gives the
user that ability. After that, I logged out again and re-logged in
using:

mysql -h lion.davjam.org -u root -p

and created a new user using:

grant all privileges on test.* to 'username'@'<my.host.name>' identified by '<users password>';


I'm following the Suse Linux 10 Unleashed manual page 520 to 525. It
makes me angry when I follow directions and they don't work.
I uninstall the whole dam thing and deleted everything again.

Okay. First thing I do when something is that frustrating is to walk
away from it, do something else and then return to it when I'm more
relaxed. It saves me from doing things like uninstalling things when I'm
only got to reinstall them later.


Regards,
David Bolt

--
www.davjam.org/lifetype/ www.distributed.net: OGR@100Mnodes, RC5-72@15Mkeys
SUSE 10.1 32bit | openSUSE 10.2 32bit | openSUSE 10.3 32bit | openSUSE 11.0a1
SUSE 10.1 64bit | openSUSE 10.2 64bit | openSUSE 10.3 64bit
RISC OS 3.6 | TOS 4.02 | openSUSE 10.3 PPC |RISC OS 3.11
.

Relevant Pages

  • Re: Any known reason why su would not work?
    ... If you're worried that someone has your root password now, ... and the command had no ... > hacker and called su, and that had just read my ... > I didn't find any obvious evidence of a hacker, ...
    (comp.os.linux.security)
  • Re: How To Move SuSE Install To A Larger Drive
    ... files from the command line. ... (will need to enter root password again when asked) ... and you should see the 'oldhomedir' file we created earlier. ... (I've added extra spaces to emphasize where the spaces should be!) ...
    (alt.os.linux.suse)
  • Re: New to Linux (Fedora Core 3) - help with network error message
    ... kernel (usually the longer line and usuallyt the second line) and press e ... You will be asked for root password. ... If you are willing ot deal with command line, ...
    (alt.os.linux)
  • Re: regarding Redhat Boot
    ... If You give root password, you can reach the command prompt. ... Write Root Password or press ctrl D to continue, ... PC is rebooting and when root password is given its showing soething like ...
    (RedHat)
  • SUMMARY: Solaris root password recovery
    ... Give it a new one using the passwd command. ... the machine to be able to do the above to erase the root password. ... prom password from the default device (i.e. booting from CD-ROM or install ... "Full" security has its drawbacks -- if, ...
    (SunManagers)