<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> 01182006 1412 GMT-6 This email is where I was months ago. I have followed thd advice at the bottom of the email. I was able to install via the db script but I still cannot gain access to the server. Following the instructions at the end of this email, at every entry I receive Access denied for user.... Wade Tim Frost wrote: <blockquote cite="mid1132621197.9746.25.camel@localhost.localdomain" type="cite"> <pre wrap="">On Sun, 2005-11-20 at 17:29 -0600, Wade Smart wrote: </pre> <blockquote type="cite"> <pre wrap="">11202005 1725 GMT-5 Tim - a question. Im still really new to linux so bear with me. My book on mysql says -> mysql will be installed as root but for security reasons dont run it as such. Its best to change the owner and group to something like mysqladm and mysqlgrp. </pre> </blockquote> <pre wrap=""> Agreed. But that affects the running server. You first need to initialise the database. That is what the mysql_install_db script is doing. Incidentally, I installed the mysql-server package (and dependencies), using synaptic, on my breezy desktop, and find that: * a special user, mysql, was created * it automatically initialised the database. * the server runs with parameter --user=mysql * all files and directories are owned by the mysql user So, if you installed the ubuntu packages, you should have the database fully functional, with the correct permissions. And the base tables will have been correctly created by running the mysql_install_db as user mysql. Check the files and directories under /var/lib/mysql. My system has the following (notice that the directories /var/.lib/mysql/mysql and /var/lib/mysql/test have *group* root - indicating that they were created during the install, and had the owner changed): tim@marvin:~$ ls -ld /var/lib/mysql/ drwxr-xr-x 4 mysql mysql 4096 2005-11-21 19:57 /var/lib/mysql/ tim@marvin:~$ ls -l /var/lib/mysql/ total 20556 -rw-rw---- 1 mysql mysql 25088 2005-11-21 15:08 ib_arch_log_0000000000 -rw-rw---- 1 mysql mysql 10485760 2005-11-21 19:57 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2005-11-21 19:57 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2005-11-21 15:08 ib_logfile1 drwxr-xr-x 2 mysql root 4096 2005-11-21 15:07 mysql drwxr-xr-x 2 mysql root 4096 2005-11-21 15:07 test tim@marvin:~$ ls -l /var/lib/mysql/mysql/ total 100 -rw-rw---- 1 mysql mysql 8778 2005-11-21 15:07 columns_priv.frm -rw-rw---- 1 mysql mysql 0 2005-11-21 15:07 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 2005-11-21 15:07 columns_priv.MYI -rw-rw---- 1 mysql mysql 9088 2005-11-21 15:07 db.frm -rw-rw---- 1 mysql mysql 0 2005-11-21 15:07 db.MYD -rw-rw---- 1 mysql mysql 1024 2005-11-21 15:07 db.MYI -rw-rw---- 1 mysql mysql 8641 2005-11-21 15:07 func.frm -rw-rw---- 1 mysql mysql 0 2005-11-21 15:07 func.MYD -rw-rw---- 1 mysql mysql 1024 2005-11-21 15:07 func.MYI -rw-rw---- 1 mysql mysql 9064 2005-11-21 15:07 host.frm -rw-rw---- 1 mysql mysql 0 2005-11-21 15:07 host.MYD -rw-rw---- 1 mysql mysql 1024 2005-11-21 15:07 host.MYI -rw-rw---- 1 mysql mysql 8877 2005-11-21 15:07 tables_priv.frm -rw-rw---- 1 mysql mysql 0 2005-11-21 15:07 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 2005-11-21 15:07 tables_priv.MYI -rw-rw---- 1 mysql mysql 9806 2005-11-21 15:07 user.frm -rw-rw---- 1 mysql mysql 156 2005-11-21 19:57 user.MYD -rw-rw---- 1 mysql mysql 2048 2005-11-21 19:57 user.MYI If the tables in /var/lib/mysql/mysql are missing, you need to run the mysql_install_db as user mysql: sudo -i # gets a shell as root su mysql # should give a shell as user mysql sh mysql_install_db Tim </pre> </blockquote> </body> </html>