Re: [GTALUG] [OT] mySQL help SOLVED

2019-06-04 Thread nick via talk
On 2019-06-04 4:00 p.m., Stephen via talk wrote: > Thank you to all who posted offers/attempts of help. I have been looking at > this part time over a few days. > > It turns out my problem was in my PHP code :( > > I went through every bit of my mysql system. Everything was fine. I did learn

Re: [GTALUG] [OT] mySQL help SOLVED

2019-06-04 Thread Stephen via talk
Thank you to all who posted offers/attempts of help. I have been looking at this part time over a few days. It turns out my problem was in my PHP code :( I went through every bit of my mysql system. Everything was fine. I did learn a few things :) But, the new upgraded version required a med

Re: [GTALUG] [OT] mySQL help

2019-05-29 Thread Jason Shaw via talk
On Tue, May 28, 2019 at 7:50 PM Stephen via talk wrote: > Can anyone spot what is wrong? > > So I connect to the server with: > stephen@Avalon:~$ mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 11 > Server version: 5.7.2

Re: [GTALUG] [OT] mySQL help

2019-05-29 Thread William Witteman via talk
I usually have to specify a database. use dbname grant all on dbname... I have not ever used phpmyadmin, but I am cautious about it, because malicious scripts are searching my websites for it all day, every day for at least the last 15 years. On Wed, May 29, 2019, 01:01 Kevin Cozens via talk wro

Re: [GTALUG] [OT] mySQL help

2019-05-28 Thread ac via talk
On Wed, 29 May 2019 01:01:23 -0400 Kevin Cozens via talk wrote: > On 2019-05-28 7:50 p.m., Stephen via talk wrote: > > It has been years. I am creating a new site with database but I > > can't get the user to have privileges. > > Can anyone spot what is wrong? > > You may find it useful to inst

Re: [GTALUG] [OT] mySQL help

2019-05-28 Thread Kevin Cozens via talk
On 2019-05-28 7:50 p.m., Stephen via talk wrote: It has been years. I am creating a new site with database but I can't get the user to have privileges. Can anyone spot what is wrong? You may find it useful to install phpMyAdmin. It simplifies administration of MySQL. -- Cheers! Kevin. ht

Re: [GTALUG] [OT] mySQL help

2019-05-28 Thread ac via talk
On Tue, 28 May 2019 19:50:51 -0400 Stephen via talk wrote: > mysql> > === > I create grants > mysql> grant all on rois3324_stephen.* to > "rois3324_stephen"@"localhost" with grant option; > Query OK, 0 rows affected (0.00 sec) > ==

Re: [GTALUG] [OT] mySQL help

2019-05-28 Thread nick via talk
On 2019-05-28 7:50 p.m., Stephen via talk wrote: > I am not on any lists for mysql. So I thought that I would ask her, > > Suggestions for a help list for mysql are most welcome. > > I have a LAMP for web site development and rarely need to touch the database > admin stuff. > > It has been ye

[GTALUG] [OT] mySQL help

2019-05-28 Thread Stephen via talk
I am not on any lists for mysql. So I thought that I would ask her, Suggestions for a help list for mysql are most welcome. I have a LAMP for web site development and rarely need to touch the database admin stuff. It has been years. I am creating a new site with database but I can't get the