Starting MySQL...

tuxrules · 06-26-2005, 12:51 PM

I am logged in as user mysql and it shows only one database "test" and not "mysql".

By the way, how do i assign password for default root account in mysql?

mdarby · 06-26-2005, 12:56 PM

Try logging into mysql as root -- this should show the mysql table.
The easiest way to administer mysql is via phpMyAdmin
(phpmyadmin.net)

gbonvehi · 06-26-2005, 12:57 PM

You can assign a password using the mysqladmin utilities.
The command is: mysqladmin -u root password "your password"

As mrdarby said, you should see it when logged in as root.

tuxrules · 06-26-2005, 01:04 PM

thanks guys for replying so fast...i really appreciate your help. I'll try phpmyadmin. I tried logging as root with

#mysql

& it gives me this error

Code:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Excuse me for my ignorance...

Tux

perfect_circle · 06-26-2005, 01:06 PM

to login to mysql as root if root password is not enabled:

Code:

mysql -u root

or

Code:

mysql -u root -p

if password is enabled.

*EDIT*
after -p press enter and you'll get a prompt to type the password.

Code:

mysql -u root -p <something>

DOES NOT MEAN login as user "root" and with password "<something>". It means login as user "root" into database "something" and you'll still get a prompt to type a password. I mention this because it's a really common mistake people do.

perfect_circle · 06-26-2005, 01:12 PM

When someone tells you login as root in mysql, it means login as the mysql root user. Not as the root system user.
If you don't specify a user with -u in the mysql command mysql will use your system username as a mysql username but you don't need to become root, in order to login to mysql as mysql root user.

tuxrules · 06-26-2005, 01:17 PM

no luck. Even with mysql -u root, it just gives the same error that i mentioned above.

perfect_circle · 06-26-2005, 01:21 PM

Quote:

Originally posted by tuxrules
no luck. Even with mysql -u root, it just gives the same error that i mentioned above.

read my previous posts.
If you have enabled a password, try

Code:

mysql -u root -p

tuxrules · 06-26-2005, 01:33 PM

thanks for your patience man!!! I got it working...thanks once again.

I'll come back here if i get more errors or i get stumped.

Tux,

PTrenholme · 06-26-2005, 01:44 PM

Quote:

Originally posted by shilo
The man pages may have the correct information. The file /etc/rc.d/rc.mysql is where most people get their information, I believe. To save you the trouble of looking, here's an excerpt that may help: [snip]

Why not put something like this at the start of the data base install script:

Code:

## Verify that we aare running as "mysql" in the "mysql" group
myname="$(id -un)"
mygroup="$(id -gn)"
if [ "${myname}" != "mysql" -o "${mygroup}" != "mysql" ]
then
    echo This script \($0\) can only be run by
    echo user \\'mysql\\' in group \\'mysql\\'.
    echo
    echo You are user \\'${myname}\\' in group \\'${mygroup}\\'.
    echo
    echo To run this script do this, as root:
    echo
    echo \# su - mysql
    echo \# $0
    echo
    echo Note that step one is becoming the mysql user. It\\'s important to do this
    echo before making any changes to the database, or mysqld won\\'t be able to write
    echo to it later \(this can be fixed with \\'chown -R mysql.mysql /var/lib/mysql\\'\).
    echo
    echo Aborting.
    exit 1
fi

This seems like a rather simple thing to do, and would save a lot of questions.

perfect_circle · 06-26-2005, 02:02 PM

I think that' s a really good idea.

elf · 06-30-2005, 07:37 PM

Code:

050226  2:24:30  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

Every time I try to run

Code:

/usr/bin/mysqld_safe &

Code:

mysql@turd:/usr$ ls -l /var/lib/mysql
total 20576
-rw-rw----  1 mysql mysql    25088 2005-02-24 11:15 ib_arch_log_0000000000
-rw-rw----  1 mysql mysql  5242880 1999-04-06 18:37 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 2005-02-24 11:15 ib_logfile1
-rw-rw----  1 mysql mysql 10485760 1999-04-04 20:04 ibdata1
-rw-rw----  1 mysql mysql     2363 1999-04-06 19:01 innodb.status.2562
drwx------  2 mysql mysql     4096 1999-04-06 18:30 mysql
drwx------  2 mysql mysql     4096 1999-04-06 18:30 test
-rw-rw----  1 mysql mysql    15065 1999-04-06 18:59 turd.err

It seems like its not installed correctly (even though it installed with slackware). Do I need to create that file?

Please, any ideas?

elf

gbonvehi · 06-30-2005, 07:54 PM

Very weird, the host (it consists of three files, host.MYD, host.MYI and host.frm) table should be inside that mysql directory that's listed there. Check if it exists, if it doesn't run mysql_install_db again with the mysql user. To do that run as root:

su - mysql
mysql_install_db
exit

If the table exists, check it's permissions, it should be owned by mysql user and mysql group and have read-write permission for user and group too.

elf · 06-30-2005, 08:10 PM

it exists at /var/lib/mysql/mysql

I'm still a linux

so it will take me a bit to figure out how to chmod it all right.

should they be 755?

edit:??

Code:

chown -R mysql.mysql /var/lib/mysql/mysql

perfect_circle · 06-30-2005, 08:27 PM

They look OK to me.
DO not start mysql with
/usr/bin/mysqld_safe &
try:

Code:

. /etc/rc.d/rc.mysqld start

instead