MySQL with Ubuntu 12.04

[Joshua K]

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.