Group,
I'm using ver 5 with winXP. I can access the test database, but can't create
a table. I can't create ANY database as I keep getting error 1044 (42000):
Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you
help?
TIA,
Wade 8 12413
W.Davis wrote: Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help?
Log in as root user. I assume you are currently logged in as test user
(test user has no access to create databases).
If you are using mysql console program, and you have not set up a
password for root user, you can log in as root like this:
mysql -u root
W.Davis wrote: Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help?
Log in as root user. I assume you are currently logged in as test user
(test user has no access to create databases).
If you are using mysql console program, and you have not set up a
password for root user, you can log in as root like this:
mysql -u root
Still doesn't work! The only thing I can work with is the test database. I
can't create at all. Also, along with this problem, I can't use the source
command from the console program, it keeps giving me the error that 'table
mysql.proc doesn't exist'. I tried running mysql_fix_privileges, but it
won't run either. I'm on a WinXP box and using version 5.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Still doesn't work! The only thing I can work with is the test database. I
can't create at all. Also, along with this problem, I can't use the source
command from the console program, it keeps giving me the error that 'table
mysql.proc doesn't exist'. I tried running mysql_fix_privileges, but it
won't run either. I'm on a WinXP box and using version 5.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Got some of it. I can now create database. However, I cannot use the source
command to create my tables. In earlier versions I could do this. What I was
doing wrong was I was not using the console PROGRAM.... I was only typing
commands into the WI NDOWS cmd console. But... still the biggest problem is
not being able to get source command to work.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Got some of it. I can now create database. However, I cannot use the source
command to create my tables. In earlier versions I could do this. What I was
doing wrong was I was not using the console PROGRAM.... I was only typing
commands into the WI NDOWS cmd console. But... still the biggest problem is
not being able to get source command to work.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Now isn't this wierd.... since I keep getting the error "1146 table
mysql.proc does not exist" when I try to run the source command, I said
'what the hell' and I entered "create table proc (id char(1))" after opening
the mysql database, and for some reason, I can NOW run the source command.
Explain that one if you can.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root
Now isn't this wierd.... since I keep getting the error "1146 table
mysql.proc does not exist" when I try to run the source command, I said
'what the hell' and I entered "create table proc (id char(1))" after opening
the mysql database, and for some reason, I can NOW run the source command.
Explain that one if you can.
Wade
"Aggro" <sp**********@yahoo.com> wrote in message
news:sl*************@read3.inet.fi... W.Davis wrote:
Group, I'm using ver 5 with winXP. I can access the test database, but can't
create a table. I can't create ANY database as I keep getting error 1044
(42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can
you help?
Log in as root user. I assume you are currently logged in as test user (test user has no access to create databases).
If you are using mysql console program, and you have not set up a password for root user, you can log in as root like this:
mysql -u root This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: Robin Tucker |
last post by:
I have some code that dynamically creates a database (name is @FullName) and
then creates a table within that database. Is it possible to wrap these
things into a transaction such that if any one...
|
by: SD |
last post by:
Hi,
Quick question, I have about 20 users in my local server and database. We
are looking to restore that database to a new server in a new network and
still be able to retain the database...
|
by: *no spam* |
last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:
Access --> New --> Project (Existing...
|
by: Manzoorul Hassan |
last post by:
I just Installed MySQL v4.1.14 and had created a Database (from a
script). But I would like to redo the Database portion of it but am not
able to drop the Database. If I do a "show database;" I...
|
by: Hemant Shah |
last post by:
Folks,
I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this...
|
by: Robert McEuen |
last post by:
Using Access 97 on WinXP
I have data in a DB2 table that I'm trying to get into an identical
table in my backend db. Based on volume of data and frequency of
download, I'm trying to avoid...
|
by: Albretch |
last post by:
.. I am trying to create a database in a MS Access DB via JDBC drivers.
I have tried both sun.jdbc.odbc.JdbcOdbcDriver and ids.sql.IDSDriver
From some reason both drivers Exceptions tell me...
|
by: Larry Rebich |
last post by:
I am trying to use the sample web template that is distributed with Visual
Studio 2005 called 'Personal Web Site Starter Kit'. After running for awhile
it fails with the following message:
...
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |