Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
in RH you can start mysql buy going into /etc/rc.d/init.d and using the "./mysqld start" command as root
you can also go (as root) into /sbin and run ./netsysv and use that to setup mysql to startup @ bootup.
if you have the default configuration (installed from the rh7.3 cd)
then u log in by doing:
#mysql -uroot
and hit enter. if there is a root password that you set, then it's:
#mysql -uroot -p
and it will prompt you for password information
not sure of a beginners page, maybe just check ont www.mysql.com for docs
and info. If you know SQL then its not hard to figure out what you are doing,
but knowing some of the mysql specific commands is great and make sure
you know about mysqladmin stuff. it should all be on the mysql website.
Distribution: Gentoo > current. Have used: Red Hat 7.3, 9, Gentoo 1.4
Posts: 400
Original Poster
Rep:
Is anyone here really familiar with setting up MySQL? I looked over the manual pages at MySQL.com and they read like Greek. It's nice that they elaborate what every little option does and all, but I'd like to know how to get it started for now. I just need to understand how to setup permissions to users in MySQL and how to log into it remotely. Would anyone know how to do this?
Distribution: Gentoo > current. Have used: Red Hat 7.3, 9, Gentoo 1.4
Posts: 400
Original Poster
Rep:
Ok, this Webmin thing would seem to be the way to go with a lot of things on Linux....very cool tool. But I think I may have made the situation worse. I went in and added passwords to the root accounts in mysql and now it won't let me have access to the mysql accounts. And yes I am logged in as root.
A simple way to create a database and a user is as follows:
mysql --user=root
mysql> CREATE DATABASE mydb;
mysql> GRANT ALL PRIVILEGES ON *.* TO mynewuser@localhost IDENTIFIED BY 'mypassword';
now to specify the privileges you want, you can look up the documentation at mysql.com. Search for GRANT.
In a lot of cases you don't always want to grant all privileges. You may want to grant only select only on one database.
eg)
GRANT SELECT ON mydb.* TO mynewuser@localhost IDENTIFIED BY 'mypassword';
To remove privileges use the REVOKE command.
I think this is the information you are looking for.
Distribution: Gentoo > current. Have used: Red Hat 7.3, 9, Gentoo 1.4
Posts: 400
Original Poster
Rep:
Well, pending recent circumstances, it has deamed beneficial for me to install RH 9 and try it out. If it stinks, I'll go back to RH 7.3. Either way I'll get everything reset. One of the reasons for doing so was because I could not access mysql anymore. Setting the password for the root username under SQL really screwed things up. I tried uninstalling the RPM and re-installing it. It still wouldn't let me in. This coupled with the fact that I couldn't play the latest version of MAME (What can I say, I'm a gaming addict! ), I will try RH 9.
In the meanwhile I guess I could do some reading on the next part of my learning SQL whilst I wait on the approximately 2 gig download. So my question is this:
I want to use this SQL database with a webpage. So this actually will lead to two questions. How would I make a webpage interact with a SQL database (a web page tutorial for me to read would be fine), and second, what program in Linux would be best to create a webpage that will use the SQL database.
I don't know any good tutorials on PHP, hopefully someone else can post that.
You can create php webpages using any text editor. As for what program is the best, I don't know. On windows I like using Dreamweaver. But it's not free.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.