From: Kenneth B. <kbr...@gm...> - 2015-02-26 00:55:29
|
On 02/25/2015 07:46 PM, Martin Steer wrote: > On Tue, Feb 24, 2015 at 09:23:58AM -0500, Kenneth Browne wrote: >> Trying to create a database at this stage of the TMG to GRAMPS page >> >>> In a terminal do the following substitute your TMG project name >>> without extension for MYNAMEtmg7 >>> >>> mysql -u root -p >>> create database MYNAMEtmg7; >>> grant usage on *.* to ian@localhost identified by 'PASSWORD'; >>> grant all privileges on MYNAMEtmg7.* to ian@localhost >> I can't ever get to the mysql prompt >> > (1) >> kenneth@kenneth-ThinkPad-X60 ~ $ mysql -u root >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: NO) > (2) >> kenneth@kenneth-ThinkPad-X60 ~ $ mysql -u root -p >> Enter password: >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using >> password: YES) > So at (1) you can't get in without a password, and at (2) you can't get > in with one. > > Given that mysql is looking for 'some user name'@'localhost'. have you > tried: > > $ mysql -u kenneth > > or perhaps: > > $ sudo mysql -u root > > or: > > $ sudo mysql -u root -p > > This may be out of date info, but at one time mysql came with a test > database (called test) open to all users. It doesn't help much with the > larger problem, but it may be some encouragement just to get in: > > $ mysql -u test All of the above. See below: kenneth@kenneth-ThinkPad-X60 ~ $ mysql -u kenneth ERROR 1045 (28000): Access denied for user 'kenneth'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ sudo mysql -u kenneth Swipe your right index finger across the fingerprint reader ERROR 1045 (28000): Access denied for user 'kenneth'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ sudo mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ sudo mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) kenneth@kenneth-ThinkPad-X60 ~ $ sudo mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) kenneth@kenneth-ThinkPad-X60 ~ $ mysql -u test ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ sudo mysql -u test ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: NO) kenneth@kenneth-ThinkPad-X60 ~ $ man mysql kenneth@kenneth-ThinkPad-X60 ~ $ I did get some results with the test followed by "h" for help but never got to a mysql> I think I will try uninstalling mysql and reinstalling, along with those connectors. Does anyone know if I need to also install mysql-client. I though I've read that all that's needed is mysql-server, but one poster on a forum suggested the need for BOTH server and client. Thanks for all suggestions, Ken > I don't have mysql installed (and my distro prefers mariadb), so can't > offer much more. If you asked in some mysql (or linuxmint) forum they'd > sort you out pretty quickly. > > Oh, and if your distro has done the right thing, you should have mysql > man pages installed now. The answer is there, if you can find it. > > $ man mysql > > And perhaps: > > $ info mysql > > M. > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > _______________________________________________ > Gramps-users mailing list > Gra...@li... > https://lists.sourceforge.net/lists/listinfo/gramps-users |