Jump to content

Recommended Posts

I had installed mysql and created my own database etc.

but then i had trouble connecting to it, so i looked at the privileges, and they seemed to ok, but it wouldnt connect!

 

Then some of the databases that come along with mysql disappeared and i only had \'mysql\' and \'test\' showing in \'mysqladmin\'.

 

I thought there was something wrong so i\'ve installed mysql again.

What i want to know is whether mysql only comes along with the two databases i.e \'mysql\' and \'test\' as i had two others before one of them which was \'library\'.

 

Will mysql work fine when i create my own database with \'mysql\' and \'test\' that comes along with it, or does it come along with anyother databases that you need inorder for it to work?

 

PLEASE PLEASE SOMEONE CLARIFY THIS FOR ME, AS IM CONFUSED!!!

 

The last thing i wanted to know was, as i have installed mysql how do i ensure that i am the root user? or grant myself all the privileges?? So that i am able to connect to it! do i need to assign myself the privileges first before i create my own database or can it also be done after?

 

I had this as a major problem before and i tried using the following:

GRANT ALL ON <mydatabase>.*TO ODBC@localhost IDENTIFIED BY <\"password\">

among other commands similar to this but it didnt work, and still wouldnt let me connect.

Link to comment
https://forums.phpfreaks.com/topic/804-mysql-database-help/
Share on other sites

Mysql database is the one which you have look for because you have a table called \"user\" which is used to add and give him privelage.

 

By default \"root\" user password <blank> is given the full rights. SO log in as root and have a look at the user table.

 

If you are using windows OS get yourself Sqlyog tool which can be really handy.

Link to comment
https://forums.phpfreaks.com/topic/804-mysql-database-help/#findComment-2651
Share on other sites

ok. thanks for replying!

 

I just wanted to know what program do i use to open scripts/mysql_install_db. ?

 

i.e when you double click the window \'Open with\' pops up to select a program inorder to open the application. im not sure what to open it as??

 

 

how do you log in as a root user and make your self the main user so that you have all privileges and also assign a password which is for you. Can someone plz show me the commands etc what i need to type to enable me to do that.

Link to comment
https://forums.phpfreaks.com/topic/804-mysql-database-help/#findComment-2662
Share on other sites

sorry if i am mistaken, but i\'m gonna treat you like a newb like pout and recommend phpMyAdmin (or some other gui mysql interface). When working with these, you\'ll find it infinitely easier to administer your DB\'s from complex tasks to simple bare-bones permissions and users handling.

 

http://phpmyadmin.sf.net

 

i also wrote a tutorial myself on how to painlessly install phpmyadmin on any of the newer linux distros. I submitted it to a pal i met at yaxay and his site seems to be down temporarily. PM or email me if you really want to read my tutorial.

Link to comment
https://forums.phpfreaks.com/topic/804-mysql-database-help/#findComment-2673
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.