MySQL with Ubuntu 12.04

[Stuart Stegall]

Using the mysql command initially and validate with that just to
validate if the issue is elsewhere.

Go n-éirí leat,
Stuart


On Tue, Jul 10, 2012 at 12:32 PM, Dan Healy <dfhealy at gmail.com> wrote:
> I ran mysqlcheck and got no results.  Thanks for the information.  It was
> worth a try.
>
> I am using MySQL 5.5.24 and trying to connect to my database with
> mysql_pconnect().  That is apparently obsolete and I should be using
> mysqli_connect().  I will have to research that some more.  I will keep you
> posted.
>
> Dan H.
>
> On Tue, Jul 10, 2012 at 12:03 AM, Stuart Stegall <keltor at keltor.org> wrote:
>>
>> Try running mysqlcheck against the mysql database.
>>
>> Go n-éirí leat,
>> Stuart
>>
>>
>> On Mon, Jul 9, 2012 at 9:26 PM, Dan Healy <dfhealy at gmail.com> wrote:
>> > I tried that.  The user does not exist.  In MySql do the following:
>> >
>> > use mysql;
>> > select user from user;
>> >
>> > That gives a list of the users.  If I drop the database and flush
>> > permissions all users created for that database are removed from the
>> > mysql
>> > database.
>> >
>> > There is something I am missing there.  I'm not going to find it
>> > tonight.
>> >
>> > Dan H.
>> >
>> > On Mon, Jul 9, 2012 at 8:52 PM, Joshua K <goodtimetribe at gmail.com>
>> > wrote:
>> >>
>> >> If you list the contents of the mySQL table does it show that user
>> >> exists?
>> >> If so maybe just comment out that line from the dump back in? If it
>> >> says the
>> >> user exists, it probably does.
>> >>
>> >> Dan Healy <dfhealy at gmail.com> wrote:
>> >>
>> >> >I downloaded a fresh version of 10.04 from Ubuntu, installed, and got
>> >> >the
>> >> >same results -- it couldn't see my wireless connection or cable
>> >> >connection
>> >> >to the internet.  10.04 is not an option.
>> >> >
>> >> >I reinstalled 12.04 and very carefully installed lamp-server and
>> >> >php5-gd
>> >> >and restarted apache2.
>> >> >
>> >> >12.04 sees the wireless connection.  The problem is with MySQL.
>> >> >
>> >> >I can import my database dump but can't create users.  When I try to
>> >> >create
>> >> >a user I get a 1396 error indicating the user already exists.  He
>> >> >doesn't.
>> >> >I have searched on 1396 and tried various tests and fixes and I still
>> >> >can't
>> >> >create a user.
>> >> >
>> >> >I will be back tomorrow for more research.  Any ideas are greatly
>> >> >appreciated.
>> >> >
>> >> >Dan H.
>> >> >
>> >> >On Sat, Jul 7, 2012 at 10:21 AM, Dan Healy <dfhealy at gmail.com> wrote:
>> >> >
>> >> >> I am trying to port my application from Ubuntu 10.04 to Ubuntu 12.04
>> >> >and
>> >> >> cannot make MySQL work as expected.  The database dump sql from
>> >> >> 10.04
>> >> >> apparently loaded into MySQL on 12.04 correctly.  The privileges sql
>> >> >seemed
>> >> >> to run to completion OK but I couldn't connect any user other than
>> >> >root.
>> >> >>
>> >> >> I went to the command line, opened MySQL as root, selected the
>> >> >database to
>> >> >> use and granted privileges to another user.  That worked OK.  I
>> >> >> tried
>> >> >to
>> >> >> open MySQL as this new user and got an Access denied message.  Any
>> >> >ideas on
>> >> >> what I am doing wrong?
>> >> >>
>> >> >> Thanks,
>> >> >>
>> >> >> Dan H.
>> >> >>
>> >>
>> >> --
>> >> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
>> >>
>> >> --
>> >> Ubuntu-us-tx mailing list
>> >> Ubuntu-us-tx at lists.ubuntu.com
>> >> Modify settings or unsubscribe at:
>> >> https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx
>> >
>> >
>> >
>> > --
>> > Ubuntu-us-tx mailing list
>> > Ubuntu-us-tx at lists.ubuntu.com
>> > Modify settings or unsubscribe at:
>> > https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx
>> >
>>
>> --
>> Ubuntu-us-tx mailing list
>> Ubuntu-us-tx at lists.ubuntu.com
>> Modify settings or unsubscribe at:
>> https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx
>
>
>
> --
> Ubuntu-us-tx mailing list
> Ubuntu-us-tx at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx
>