Question about Sun MySQL

2 Answers

MYSQL Access denied

Hi,

First time I have taken a dedicated server and on that I have very less knowledge about MYSQL and Linux commands.

When I am trying to enter
shell>MYSQL
it is giving access denied message. Even when I am using
shell> mysql -u root -p
I am getting this error message "Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

Can some please help in why >MYSQL is not working and how to retrrieve the mysql root password.

Thanks in Advance
Amjad

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Hi Buddy,

Try this option....

mysql -u root -p

mysql will then ask you for the password give the proper password.

For changing mysql root password

mysqladmin -u root -p password <<newpwd>>

then mysql ask you to give password this is the old password and now the new password for the root will be newankush.

Posted on Sep 29, 2008

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

You can also use:

sudo -s

Then whatever code lines you need to have all permissions on the system

Posted on Feb 24, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Could not connect to MySQL


Hi;

You can start/stop the mysql service on the server by logging into the server as root from the command line interface and run the following command/s.

service mysql stop
service mysql start
service mysql restart

You can also use the following if the above does not work fine.
Fix Toolbox for MySQL
https://www.fixtoolbox.com/repairtoolformysql.html

Jul 07, 2016 | Wolfgang Schmuck MySQL

Tip

Keeping Your Dedicated Server Safe


Dedicated servers can be an essential element of business growth. All your information is easily accessible to anyone authorized to access and use. There are different<b> operating systems</b> to select, depending on your needs. For example, Windows operating systems are optimized for networking and collaboration, which may be why they are the most popular. But what if the server is attacked? All your information is lost or seriously compromised, which may affect the performance of your business operations. There are many precautions must be taken to try to maintain your dedicated server secure and protected against attacks. Here are some tips to keep your data safe.<br /> <br /> Make sure your software is updated and patches<br /> <br /> If a service is not used, disable it. There is no sense wasting space<br /> <br /> Regularly check the system logs looking for suspicious activity or invalid<br /> <br /> Create a firewall can block the IP for a specified period of time<br /> <br /> Make your passwords and change them every 3 months<br /> <br /> Antivirus consistent schedule [for Windows] and rkhunter [for Linux] controls<br /> <br /> Make regular backups of all data, but do not store the backup server<br /> <br /> Install only certified applications on the server<br /> <br /> Security Alerts Cyber tracking technique should be applied to systems and programs<br /> <br /> Use all the other hardware used to access the server and everything, which develops applications for servers<br /> <br />

on Feb 07, 2011 | Computers & Internet

3 Answers

How to fix mySQL corrupt databases?


you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-: http://www.sql.repairtoolbox.com/

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Just installed Ubuntu Server. I need a graphical user interface, and downloaded one but computer still boots to dos-like interface. I don't know Linux commands. How to get GUI?


1-If you are presented with the command line after Linux boots, And after you login and end up at the command line prompt, you Type:
STARTX
The above command start up the GUI from the command line, and Get you in the Graphic GUI environment of Linux.
2-If you Linux computer start up with the GUI, and you are Taken to the desktop environment, there is a way to access the Linux command line.
From your desktop, you can go trough the startup menu and choose the " TERMINAL", and this will let you access the Command line. You will end you with a windows with the Command prompt from within the desktop.
In summary, accessing the command line interface or the GUI Can both be done on your Linux computer, weather your system is Setup to start with the Shell interface or the GUI.

Nov 28, 2011 | Canonical Ltd. Ubuntu

1 Answer

MySQL Error Number 1045 Access denied for user 'root'@'localhost' (using password: NO) If you want to check the network connection, please click the Ping button. That is the message i get when i...


Hi,

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installations is still needed to connect to the server. In this case please select skin now and re-run the Configuration Wizard from the start menu.


Please revert me, if you need more assistance, i would be very glad to assist you more.
If you were satisfied with the solution please rate this sollution.

Thanks For using FixYa!
Vinod Kumar J

Nov 28, 2010 | Sun MySQL

1 Answer

MySQL Database


THE SYSTEM REQUIRMENTS ARE
MySQL Tools
1. A SQL server : This is an engine which provides access to your databases.
2. Client programs for accessing the server : A program allows you to enter queries directly and view results
3. A client library for writing your own programs : You can write your own programs into the client library using C.
Recommended Hardware Requirements For Mysql Installation
  1. Pentium V processor
  2. 128 MB RAM
Note that MySQL can be installed on a platform with as little as 32 MB
RECOMENDED SOFTWARE TOOLS for better performance
IT is recommended to have at least 128MB memory.
You can freely download MySQL from the website http://www.mysql.com MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others

Sep 08, 2008 | Sun MySQL

4 Answers

MySQL Error Messeage


When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command -
./bin/mysqladmin -u <username> password

Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>

Jul 27, 2008 | Sun MySQL

3 Answers

How to set a folder with small program to run on linux+apache


Dear Rajiv

First make sure that your Apache server is running properly.
For this type http://localhost and see the result.

If you want to test PHP you can create a php test file by yourself.

Goto the www folder in apache director. create a file , name it anything.php. Edit the file and simply write "phpinfo()" without quotes . check the output.

It means that your apache server is fully capable of PHP scripting.

Cheers, Parveen

Jan 25, 2008 | Computers & Internet

1 Answer

Regarding perfomance commands


Start with Webmin http://www.webmin.com/ . It can provide some more visibility for your linux server's performance and resource usage.

Oct 01, 2007 | Computers & Internet

1 Answer

MSACCESS Multi user APplication


Access is never good for multi-user with more than about 10 users! MS say: use SQL server. Of course, it all depends on the complexity of the app, the amount of data, transaction rate etc. You can also try putting the backend on a "real" server (15K rpm SCSI or sSCSI disc, Xeon CPU) and give it as much RAM as you can afford (at least 4GB) then you might get reasonable performance. If you can't do it any other way & a licence for MS SQL Server is out of the question, use MySQL as a backend: you can make Access clients talk to it as there is a free Access driver for it. You can even run MySQL under windows: you don't need Linux (although it will run faster under Linux). Setting it up is fairly easy and it will outperform an Access backend by at least an order of magnitude, if not 2 or 3 :)

Sep 19, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

478 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

Cosma Papouis
Cosma Papouis

Level 3 Expert

409 Answers

Robin Hill
Robin Hill

Level 3 Expert

1262 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...