Linux newbe needs help

[linuxnewbe]

Hi I am a newbe to Linux and CLI stuff and am tring to install zabbix. I have ran yum and installed all the correct packages I now am up to setting up mysql. Sorry for been so dumb but what what user name do i need to put in the <username> box as I have tried all user accounts and get the access denied.

mysql -u<username> -p<password>
>create database zabbix;
>quit;
cd create/mysql
cat schema.sql |mysql -u<username> -p<password> zabbix
cd ../data
cat data.sql |mysql -u<username> -p<password> zabbix

[schul]

mysql has it's own user databse.

If you haven't configured anything yet the default user is root with no password.

[linuxnewbe]

I have not set up any mysql users. SSo I used root and now get this message


[root@localhost zabbix]# cd create/mysql
[root@localhost mysql]# cat schema.sql |mysql -uroot -p<password> zabbix
bash: password: No such file or directory
[root@localhost mysql]#

Please help

[Valerie]

As mentioned by schul, there is NO default password for root account on MySql, so the proper command would be :

[root@localhost mysql]# cat schema.sql |mysql -u root zabbix

Once your done setting up Zabbix, I propose to add a password for that root account. Google it up.

[Nate Bell]

Even easier, since you're alread root, running:

[root@localhost mysql]# cat schema.sql |mysql zabbix

will work as well because you will be accessing mysql as the user root. The -u switch is useful for running as users you aren't logged in as.

Nate

[linuxnewbe]

Thanks to all that helped me. I have now installed Zabbix and can get to the web front end but I can not log in. No matter what user name I put in I get no error message and still stay log in as guest. Any ideas

[schul]

default login is admin with no password.

Once you validate the form you should see :

Press here to disconnect/reconnect

and on the bottom right corner : Connected as Admin

[linuxnewbe]

I have tried that. It almost appears the code behind the enter button dos not work. You press the enter button and the admin user name stays there but it does not log me in and on the right hand side is still says guest.

[zirconx]

I'm posting this for the benefit of those who have this problem in the future and come across this thread.

I think the problem is that its not obvious when you login. The only thing that happens is that you get a 'click here to connect/disconnect', which to me comes across as 'click here to try to log in again'. But really you are logged in, and clicking on the link will log you out and give you the login form again.

Hope this is helpful.