jwwceo Posted April 19, 2008 Share Posted April 19, 2008 Hello, I am installing mysql on my first dedicated server, and I am having some problems. I hope it's something simple... I have downloaded the sourceballs, unzipped them, and ran the compile command, only to get this error: Any idears??? [root@localhost mysql-5.0.51a-linux-i686]# ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h localhost.localdomain password 'new-password' Alternatively you can run: ./bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@localhost mysql-5.0.51a-linux-i686]# nohup: redirecting stderr to stdout chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/src/mysql-5.0.51a-linux-i686/data STOPPING server from pid file /usr/src/mysql-5.0.51a-linux-i686/data/localhost.localdomain.pid 080418 19:51:13 mysqld ended Quote Link to comment Share on other sites More sharing options...
gluck Posted April 19, 2008 Share Posted April 19, 2008 looks like you don't need to configure. Did you read the install file with the distribution? Normally it will have all the instructions. Quote Link to comment Share on other sites More sharing options...
jwwceo Posted April 19, 2008 Author Share Posted April 19, 2008 I read the instructions better, and see that this version does not need to be compiled...so I have MySQL installed, I am pretty sure...but I have some very basic questions... in order to run any of the test commands like: bin/mysqlshow I need to add this to the code bin/mysqlshow --user=mysql I am assuming I am operating as root, and don't have access to the files, but how do I operate as mysql?? The only logon I have on my server is root. I guess I am a little confused as to the different types of users. From what I can tell, there are linux users, and then separate mysql users, one of which is also called root??? The documentation is a little ambiguous to me. Any tips would be great!! James Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.