| View previous topic :: View next topic |
| Author |
Message |
woody03
-
Joined: 16 Apr 2004
Posts: 103
Location: U.K>West Midlands>Walsall,
|
 Posted: Sat Sep 25, 2004 6:43 pm Post subject: adding another MYSQL database.. |
 |
|
Is it possible to make another MYSQL database without installing PHPMYADMIN?
Thanks
Woody
_________________
 |
|
| Back to top |
  |
 |
k1ll3rdr4g0n
-
Joined: 04 Jul 2004
Posts: 609
|
| Posted: Sat Sep 25, 2004 7:23 pm Post subject: |
|
|
Yes...but why wouldnt you want to install phpMyAdmin?
_________________
 |
|
| Back to top |
 |
|
woody03
-
Joined: 16 Apr 2004
Posts: 103
Location: U.K>West Midlands>Walsall,
|
| Posted: Sat Sep 25, 2004 7:25 pm Post subject: |
|
|
because im lazy :P and i installed phpmyadmin and it says no provelages and i thought i handt installed it right...
edit-how do i change the permissions for the mysql database. i have a program that adds databases but i dont have the correct permissions
_________________
|
|
| Back to top |
|
|
k1ll3rdr4g0n
-
Joined: 04 Jul 2004
Posts: 609
|
| Posted: Sat Sep 25, 2004 8:03 pm Post subject: |
|
|
You must set your permissions manually and the only way that ive been able to do it is inside phpMyAdmin. Do you get a xxx.xxx.xxx.xxx is not allowed access to mysql ? xxx being numbers
_________________
|
|
| Back to top |
|
|
woody03
-
Joined: 16 Apr 2004
Posts: 103
Location: U.K>West Midlands>Walsall,
|
| Posted: Sat Sep 25, 2004 8:17 pm Post subject: |
|
|
nope in the program i get "acess denioed for user '@localhost' to database 'test'"
_________________
|
|
| Back to top |
|
|
k1ll3rdr4g0n
-
Joined: 04 Jul 2004
Posts: 609
|
| Posted: Sat Sep 25, 2004 8:24 pm Post subject: |
|
|
are you using root? Do you have a pass set for root?
_________________
|
|
| Back to top |
|
|
woody03
-
Joined: 16 Apr 2004
Posts: 103
Location: U.K>West Midlands>Walsall,
|
| Posted: Sat Sep 25, 2004 8:34 pm Post subject: |
|
|
ah found the prob..didnt know i was meant to use "root" as the user name...
thanks
_________________
|
|
| Back to top |
|
|
k1ll3rdr4g0n
-
Joined: 04 Jul 2004
Posts: 609
|
| Posted: Sat Sep 25, 2004 9:26 pm Post subject: |
|
|
You mean to tell me you dont have a pass set for root!!!!!!11!!!!
_________________
|
|
| Back to top |
|
|
woody03
-
Joined: 16 Apr 2004
Posts: 103
Location: U.K>West Midlands>Walsall,
|
| Posted: Sat Sep 25, 2004 9:30 pm Post subject: |
|
|
yep :( how do i set one then?
_________________
|
|
| Back to top |
|
|
olly86
-
Joined: 25 Apr 2003
Posts: 993
Location: Wiltshire, UK
|
| Posted: Sat Sep 25, 2004 10:50 pm Post subject: |
|
|
you can use MySQL Administrator from the MySQL group. I prefer it over phpMyAdmin...
_________________
Olly |
|
| Back to top |
|
|
Foxified
-
Joined: 13 Apr 2004
Posts: 487
Location: Canada
|
| Posted: Sat Sep 25, 2004 11:00 pm Post subject: |
|
|
| olly86 wrote: | | you can use MySQL Administrator from the MySQL group. I prefer it over phpMyAdmin... |
nice!
_________________
 |
|
| Back to top |
  |
|
k1ll3rdr4g0n
-
Joined: 04 Jul 2004
Posts: 609
|
| Posted: Sat Sep 25, 2004 11:23 pm Post subject: |
|
|
oh my =X no pass for root......
_________________
|
|
| Back to top |
|
|
|
