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. <div class="gmail_quote">On Tue, Jul 10, 2012 at 12:03 AM, Stuart Stegall <<a href="mailto:keltor@keltor.org" target="_blank">keltor@keltor.org</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Try running mysqlcheck against the mysql database. Go n-éirí leat, Stuart <div class="HOEnZb"><div class="h5"> On Mon, Jul 9, 2012 at 9:26 PM, Dan Healy <<a href="mailto:dfhealy@gmail.com">dfhealy@gmail.com</a>> 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 <<a href="mailto:goodtimetribe@gmail.com">goodtimetribe@gmail.com</a>> 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 <<a href="mailto:dfhealy@gmail.com">dfhealy@gmail.com</a>> 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 <<a href="mailto:dfhealy@gmail.com">dfhealy@gmail.com</a>> 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 >> <a href="mailto:Ubuntu-us-tx@lists.ubuntu.com">Ubuntu-us-tx@lists.ubuntu.com</a> >> Modify settings or unsubscribe at: >> <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx</a> > > > > -- > Ubuntu-us-tx mailing list > <a href="mailto:Ubuntu-us-tx@lists.ubuntu.com">Ubuntu-us-tx@lists.ubuntu.com</a> > Modify settings or unsubscribe at: > <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx</a> > -- Ubuntu-us-tx mailing list <a href="mailto:Ubuntu-us-tx@lists.ubuntu.com">Ubuntu-us-tx@lists.ubuntu.com</a> Modify settings or unsubscribe at: <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-tx</a> </div></div></blockquote></div>