On 05/07/2017 05:45 AM, Richard Owlett wrote: > On 05/06/2017 04:05 PM, Dick Steffens wrote: >> <...> >> >> When you installed MySql it should have created the user "root" and >> had you create a password for user root. So in the above command, >> substitute "root" for "username" (don't use the quote marks). >> If MySQL is running, [SNIP ;] > It wasn't; > It responded with an apparently infamous error: > " Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' " > A web search and an "ahaaa moment" and a solution. > Debian is replacing the old mysql with current mariadb. > I managed to end up with a non-functional mixture. Not sure if operator > error or one those bugs that has Debian 9 still in testing. > Purged mysql* and installed appropriate mariadb client and server packages. > > [Things not as simple as I thought. See answer to last question.]
Yeah. I recently installed Ubuntu MATE 16 on another system. When it came time to install the database I looked at the instructions for mariadb. I didn't have the time to understand them, so stuck with MySQL. One of these days I'll have to go back and try mariadb again. >> To test php put the following into a file named index.php, >> >> <html> >> <body> >> <?php phpinfo(); ?> >> </body> >> </html> >> >> and then put it in the same folder as your current index.html, [snip] > The Debian version of index.html is so kind as to actually tell the user > what directory it is in. > This test also passes ;} That's very kind of them. It makes setting up a web server so much easier when you already know where to find things. > <...> >> When you installed MySQL, did it ask you to create an administrator's >> password? That's the one you should use here and is the same one used >> in the example above on how to get into the mysql monitor. In my case >> the administrator is root. > This is my comment I mentioned above - "root" can mean to many things. > Above, when I thought mysql now ran, I was logged into Debian as root - > not as richard. > As Debian's root user "mysql - u root" alone will run. > Also "mysql - u root -p<cr>" will prompt for a password and will run if > what was entered for "MySQL application password for phpmyadmin" is > given *BUT NOT* for a "bad" password. > > I can't pursue this at the moment. > It will have to wait till this afternoon. Yes, root has more than one use. It can lead to confusion for awhile. In general, a "system" needs an administrative user, often named root. The confusion comes from there being more than one "system" in a system. There's the operating system, which is the one we usually think of. But then there's the database system. And while the same name can be used, it bears no relation to the operating system user root. You could name one Fred and the other Ethel, or you could name both of them Fred and get the same results. (At least I think you could name the OS root user Fred. I'm not sure about that. I know you could name the DB administrative user Fred.) To be safe, and have other folks know what you're talking about, it's probably safest to stick with root for both, as long as you understand that they are in a different context. > Thanks for your assistance. You're welcome. -- Regards, Dick Steffens _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
