jjaenagle
May 21 2008, 10:10 PM
ok so i am trying to transfer mediawiki's but i am having trouble with exporting importing the database. I am using phpmyadmin on both sides of the hosts. When i do the import i get this. QUOTE SQL query:
-- -- Database: `apolopedia` -- CREATE DATABASE `apolopedia` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation #1044 - Access denied for user 'jaenagle'@'localhost' to database 'apolopedia' I tried to give my user all rights, but it gave me this also. QUOTE SQL query:
GRANT ALL PRIVILEGES ON * . * TO 'jjaenagle'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
MySQL said: Documentation #1045 - Access denied for user 'jjaenagle'@'%' (using password: YES) Do you guys have any advice?
Reply
sonesay
May 21 2008, 10:24 PM
It appears you do not have the right privileges. If you have no control of setting it i.e your using MYSQL on a remote host you have little or no control over then you cant do much about it.
Reply
jjaenagle
May 21 2008, 10:47 PM
can i contact the admins and see if they can grant me privileges? what do i need to do? im very new to this. i have asked the same question in their forum so hopefully, someone can help me out.
Reply
jlhaslip
May 22 2008, 04:14 AM
The database user name is always prefixed with your cpanel name and an underscore. example: my Cpanel name is jimbo and it causes the db_username to have a prefix of jimbo_ (with the underscore). In the configuration file for the script being installed, or in an SQL command like above, I would use the db user-name of jimbo_username to access the DB where username is the user for that db.. You appear to be missing either the prefix or the username in the above example you quote.
Reply
Recent Queries:--
transferring a mysql database 1044 - 107.96 hr back. (1)
-
как переводится guangdi - 283.80 hr back. (1)
Similar Topics
Keywords : transferring sql database- Mysql Database Not Working
- (3)
- Ips Installer Database Details [resolved]
- It wont accept localhost... (6)
CODE Access denied for user 'skyed211_central'@'localhost' to database
'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" />...
Mysql Database Setup : Setting Up Mysql Database
- Guide to use MySQL database in your site (6)
A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
Phpmyadmin
- Create new database: No Privileges (7)
i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ...
Is The Database System Gone Again? [resolved]
- Errors on PHPMyAdmin again (12)
I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca...
Changes In Phpmyadmin
- Access to my database from program not working anymore. (0)
I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
explaining this correctly). I run a newsletter system on my website and the details of the people
who subscribed are in a MySQL database. To get those data from the database and to send the
newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ...
Transferring Files From One Host To Another
- Take my site to trap17 (8)
As I said, I had to move my web site away from Trap17 temporarily because I had ran out of disk
space. Now, when my upgrade is finalised, I would like to ask for a little assistance. The provider
I will be moving my site from, back to Trap17 also uses Cpanel, and the admin let me know to do a
backup and that backup could be simply transferred via FTP to my new provider. The backup includes
all my files and MySQL data, in other words, the whole web site. It is in a .tar.gz format. How do I
get all this across? Do I 'unzip' the file and then transfer them bit by bi...
How To Crate Mysql Database?
- urgent help (7)
Hi everyone!
I'm trying to make in my site a page system that allows me to create users
account (with a foto for every user)...
I'm doing that in PHP, I learned all I have to
know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
is messing: ...
Need Help With My Database
- I cannot transfer my old site's database (19)
I Couldn't import my database info via Import from php my admin and i got the .sql file from the
php my admin of my old hosting and every time i try to import it give me an error that i don't
have the permissions to do.... /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" /> What shall i do?? I need Help Please...
Installing Phpbb
- database problem (0)
Hey guy's, ive done as you said and tried to install my phpbb without fantastico. I have got to
the the install page then i get a mysql error QUOTE Warning: mysql_error(): supplied argument
is not a valid MySQL-Link resource in /home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/tdm/public_html/forum/phpBB2/db/mysql4.php on line 331 phpBB : Critical Error Could not
connect to the database Im not sure why this has happened as i have never really used mysql for
...
Database Connection Problem
- phpBB2 installation error (5)
*edit* Ok well the original problem has been solved. I have installed phpBB2 on my new how here.
Transfered all of the database files over. On my new forums all of the old posts and everything
shows up right. The problem is when I click the "Go to administration panel" at the bottom it links
me to log into my ACP on my old forums. It changes the url and all. If I hover over the link it
says that it will be directed to the right way, the way I want, but it doesn't. Does anyone
know anyway to fix this?...
Database Errors!
- Started after HDD change.. (5)
Hello, I am having database errors. They started after yesterdays HDD change. Its all fine when i
refresh site, they not that often but still i get them. It says "could not connect to database". And
i also received mail from gamma.xisto.com which says: QUOTE There has been a problem with the
database! This is a notice email to let you know that SMF could not connect to the database,
contact your host if this continues. so i am contacting my host.....
Transferring One Forum Data To Another Forum
- How To Do This ? Another forum help. (7)
I want to creat another Forum and delete the old one with the same Domain. But is there any way to
transfer all the topics in the old one to the new one with proper sorting , date created , ..... ?
Do I have to creat another MySQL Data base , Uername , ..... ? Please help me. Thank you. Topic
title modified. Please use complete sentences. ...
Database Is Deleted
- database is deleted today (6)
Today ,I access to my website and It can't connect to database,so I came to cpanel and I saw
that my database is deleted.I have a question here ,why do my database is deleted?...
Trap17 Database Problems?
- (10)
is it just me or is trap17 having issues now adays? for the past two days the forums have basicly
been down except for a small period of time last night and just starting like 5 minutes ago..... is
it just me, or is everyone getting this?...
Mysql Database Problem
- appears to be deleted, but still has data (6)
Hello. My Mysql databases appear to have been removed off of my account, yet according to my
cpanel, space is still being used on databases. Hopefully I haven't lost any of my data,
because I haven't taken a backup after recent updates, but If I have, I'll have to make do
with previous backup. Any idea what's wrong? Here's a quote from my cpanel QUOTE
Mysql databases 0 / 99 PostgreSQL Databases 0 / 99 Disk usage 13.16 / 150.00 MB SQL
Disk usage 2.99 MB As you can see, my database data still appears to be on the system, b...
Recommand A Good Database Module Or Component On Mambo
- (0)
Hi guys, I want to have a database function in my mambo website, and I was wondering if it its easy
to upload a Microsoft Access database into Mambo or if there is a Mambo Module or Component that
adds a database feature to the website? My database would be quite large several thousand entries
and I would like to enable to end-user to cross search on several variables on the database such as
by 'location' and 'Services offered' so any suggestions on which is the most
suitable database prog around for my needs? Thanks in advance!...
Is It Possible To Move Only Part Of A Mysql Database
- more like copying it and putting it elsewhere (4)
Ok, well on my forums, i have two different forums, one for Role Playing (Harry Potter Role Playing
not $3x) and the other is for general harry potter discussions, and i added over 100 smilies to
my rpg forums, and i am guessing that the area that they store the shortcuts for it is in a mysql
database because i cannot find it anywhere else, and so i am curious if there is any way that i can
copy the part of the mysql database and move move to copie to the other database, so i dont have to
enter over 100 shortcuts AGAIN....because i basicly added all of the yahoo me...
Phpbb Forum Installation Problem
- Update Database Error (4)
Guys i was trying to install a phpbb modded forum, i followed this tutorial i had, and was about to
install it fully when i got this error message An error occurred trying to update the database
Table 'phpbb_admin_nav_module' already exists If anyone could tell me how to fix this it
would be greatly appreciated. EDIT: I talked to a friend about the subject and he said i had to
enter something after phpbb_ in the prefix for data tables or something, so then it came up with a
file i had to download and ftp to the forum. So once i did that, i tried the forum ...
X7chat2_0_0 Sql Database Privledge Error
- (2)
Im trying to set-up x7chat2_0_0 and i have entered all of the information the correct way, but i try
to run the install program and it says that i do not have permission to access the database...but
for the name i have it set for ALL RPIVLEDGES.. any suggestions?...
Mysql Database Problem
- (1)
I was working on my site and the scripts said couldn't connect 2 database so when i went to
check they were gone and i can't make anymore...
Help With Mysql
- Database Parameters (2)
Hi, I need some help setting up a mySQL. I have install an auto members area script. Now it is
asking me for the following information: QUOTE Database Host: MySQL host address - localhost
will work in most cases Database Name: The database must already exist before installation
Database Username: Username to access MySQL Database Password: Password to access MySQL (this will
also used as the initial admin login password). I have never set anything like this up before.
Can someone please help me set this up properly. Thank you....
Database Error
- down down... (11)
QUOTE Warning: mysql_connect(): Can't connect to local MySQL server through socket
'/var/tmp/mysql.sock' (2) in /home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php
on line 67 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in
/home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 70 ERROR: Cannot find
database guangdi_i Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
/home/guangdi/public_html/ons-com-ru/sources/Drivers/mySQL.php on line 103 There appears to be...
Transferring Domain To Computinghost.com ?
- (3)
I'm currently moving my site to computinghost.com .... so, I've set up an account ....
now what? .... as I already have my own domain name, it asks me to "update my nameserver" .... how
do I do that? also, does anyone know how I get access to computinghost cpanel? .... oh and,
please keep it simple people .... Cheers .... ~M~ ...
Database From Astahost To Trap17
- possible? (4)
Hi all, I just got webspace on trap17. Before I had webspace on astahost, but couldn't get
enough credits there. I had a forum there. Is it possible to put all what was there to here. I
tried, but then my forum wants to redirect me to astahost and that's not what I want. Thanks in
advance, Moody...
Mysql Database Problem !
- (19)
Ok my site was running like with no problems from the mySQL database for six months even more now it
was made on PHP - Nuke i didnt touch anything when suddenly yesterday it said that there is a
problem with the Database and we will be back shortly blah blah blah... anyway the site wasnt back
about an hour ...i deleted the whole PHP-Nuke installation deleted the mySQL scripts etc etc and
tried to start everything from scratch... Ne way what i wanted didnt happen... when i installed the
new php-nuke the same error occured... it said that there are problems with the mySQL...
What's Going On With The Mysql
- database error and gd+ problems (6)
this error is coming up Database error in vBulletin : Link-ID == false, connect failed mysql
error: mysql error number: 0 I saw the problem the cpu and memory was at overload. Why is that?
Also our images ain't coming up for gd+ and we had to disable image verification so new members
can join...
Save Database To Harddrive
- Save database to harddrive (5)
Is it possible save database from this server to my harddrive /unsure.gif' border='0'
style='vertical-align:middle' alt='unsure.gif' /> or not I couldn't find right opration in
myPhpadmin. I found "export" button in this tool but there are so many options and I am a little
afraid to use it becouse I don't want to loos my data (actualy I wan save it /wink.gif'
border='0' style='vertical-align:middle' alt='wink.gif' /> ). Or maybe it can be done throuth ftp
browser? There are a lot of defoult folders (I even don't know for what are thay. I know just
bub...
Mysql Database Backup/restore Error
- error with restoring backed up .sql file (3)
hi there, im just wondering if anyone can tell me what is wrong when im trying to restore my sql
databsse (sorry if this is in the wrong section but i guess this is the only section that i think
this will fit in) QUOTE SQL-query: CREATE TABLE IF NOT EXISTS `e107_banlist` ( `banlist_ip`
varchar( 100 ) NOT NULL default '', `banlist_admin` smallint( 5 ) unsigned NOT NULL default
'0', `banlist_reason` tinytext NOT NULL , PRIMARY KEY ( `banlist_ip` ) ) ENGINE = MYISAM
DEFAULT CHARSET = latin1 QUOTE MySQL said: Documentation #1064 - You have a...
Cpanel And Mysql Database
- My cpanel is busted and sql database (7)
For some reason i login into my cpanel then it goes all blank... then next thing my mysql database
shuts down... now i cant fix anything since i dont got cpanel... i cant access anything on my site
someone please help me....
Looking for transferring, sql, database,
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for transferring, sql, database,
*MORE FROM TRAP17.COM*
|
advertisement
|
|